How to use a query to "count" then pass on that number to a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a query that counts the number of records then passes it onto
a textbox on a form. I managed to create a query to count, but i dont know
how to bring that number and put it into a textbox. I will want it to do it
on an afterupdate of a diffrent item on the form.

thank you
 
I want to make a query that counts the number of records then passes it onto
a textbox on a form. I managed to create a query to count, but i dont know
how to bring that number and put it into a textbox. I will want it to do it
on an afterupdate of a diffrent item on the form.

thank you
Click to expand...

The simplest way is probably to set the Control Source of the textbox
to

=DCount("*", "tablename", "criteria")

rather than using a totals query.

John W. Vinson[MVP]
 
Back
Top