1 Form - many queries

[cindy007]

Hi,
Is it possible to use one form to preform different queries over different tables.
ie, Query by Form, querying, table XYZ, or the user can choose another query on table ABC.
Does that make sense?

Cindy

 

[ColinEssex]

Hi Cindy

You can use more than one record source, but I think you'll need the same fields.

I may be wrong on that, the closest I got to doing it was having 2 queries and depending on a certain selection then the appropriate query was selected as the record source.

Let me know if you need any more help.

Col