Trying to populate a text box on form with the result of a query

[cec]

Hello All



this is my situation...

I have several different queries for a form with a lot of command buttons. I had an idea and hope it's possible!

I would like for the result(count of records) of a query to populate automatically when you open the form in a unbound text box with out pushing the command button to actually get the result(with details instead of just a count that i'm looking for)....

Please help!

also the query has different criteria therefore i need the result of the whole query not just a particular column in the query.

[pbaldy]

Try a DCount() in the control source of the textbox.

[cec]

I have tried this and did the DCount from the from/ the table / the query and it's giving me #Error .......

[pbaldy]

Hard to figure out the error when I don't know what you tried.

[cec]

sorry..
=DCount([Manstat_19],"cert")

[pbaldy]

Both are string arguments. Try

=DCount("[Manstat_19]","cert")

or simply

=DCount("*","cert")

[cec]

This is driving me banana's!!!!!! ...

Not sure what i'm doing wrong but it is still giving me the #Error message. I have even did make-table query .....

[pbaldy]

Cert is the name of the query? Can you post the db here?

[cec]

sorry ManStat_19 is the name of the query and "cert" is the column that I would be counting how many records in the query with the set criteria's....

[cec]

ok now i did it backwards : DCount("cert", [Manstat_19]!cert) and it gave me #Name? message

[pbaldy]

Try

=DCount("*","[Manstat_19]")

[cec]

BOOOOYYYYAAAAAAA

GOT IT!!!!!!! =ZDCount("cert","ManStat_19") .............. I took out the [] and it worked!!!!!!!

thanks soooo much for helping me!!!

[pbaldy]

No problemo!