Display multiple query results in one form

[edsac64]

Hi, not sure if this is a Form or Query issue. I'm using Access 2003 and I have several processes that run off a main form. Data is being taken in, moved around, deleted based on dates, exported to Excel spreadsheet etc. I'd like to show metrics on the main form, if possible, that would populate fields dynamically as the processes occur. For example, the first process is to import data from a text file. After the import is completed, I'd like to query and display the count of the items on the main form. Am I asking for something too complicated? Thanks! -Ed

 

[John Big Booty]

A Form can only have on table/query as a Record Source.

So you will either need to combine all you queries into on query, or use a number of sub forms to display the results of your various queries.

 

[edsac64]

Thanks! How about pulling all the data into a report format to be displayed at the end of the processing? I remember seeing someone do something with Union queries, or something along those lines.

 

[John Big Booty]

You could certainly do that. If you can do it for a report you can also do it for your form.