Question:
At runtime, how do I change the query that I’m using with my data controls to be one a user selected? I don’t want to keep the same name in the RecordSource property all the time.
Answer:
You can change the RecordSource of the data control at run time — just give it the name of the query you wish to use. You can also change the database name property at run-time.