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

[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

 

[John Vinson]

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

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]