HELP WITH FORMS.....

[Guest]

Hi

Can anyone tell me if it is possible to link multiple queries to a single
form without using subforms?? Is so, how do you do this???

Thanks

 

[Guest]

Hi Jo,

The only way to use multiple queries with a single form is to use VBA code
to change the recordsource of the form. However, you will still only be able
to use one query at a time.

Can you expand a bit more on why you have such a need?

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi

Can anyone tell me if it is possible to link multiple queries to a single
form without using subforms?? Is so, how do you do this???

Thanks

 

[Guest]

Jo:
I have used multiple queries in a single form. The easiest way is to create
a query that contains the multiple queries that you need. In the query
designer, display the show table dialog, click the queries tab and add the
desired quieries. Performance issues might develop, but simple multiple
quieries work ok.

bob