I have a system with question banks stored as tables in a A2K database. A user selects a table and this should then be able to change the command text before the main test form is loaded. I already have established a connection called connection1 and a command called tests. The associated fields do not need to change only the name of the name of the table in the command text.

I have made several attemps using ADO to do this without success.

help appreciated

John Lamb