Running a query in the background and return result in control

[milkman2500]

Hi,

I have several queries that perform an audit on data. I want to create a form that has two buttons, multiple labels and textboxes. When the first button is pressed, it runs all queries and returns a count of the records within each query into the corresponding textbox. Then I want a a button that will clear all textboxes. I don't want to see the queries, I just want them to run in the background and the count results to be populated in the textboxes.

So for example, it would return:

Check1: 3
Check2: 6
Check3: 2
Check4: 0

Thanks!

 

[pbaldy]

Along the lines of

Me.Check1 = DCount("*", "FirstQueryName")
Me.Check2 = DCount("*", "SecondQueryName")

 

[milkman2500]

Great, thanks!

 

[pbaldy]

Happy to help!