Textbox to Display a Specific Text till Query Runs

[RAJESHKUMAR R]

Dear Friends,



I have text box in a Form, which is designed to display count of Records from a Particular Query i.e. “FR_FO”

I am using below formula in Control Source (Design Mode), which gives correct result!

=Format(DCount("[Part_Number]","[FR_FO]"),"00000")

However, The Concern are support I am looking for here is, when I open the Form (No Query Result Run yet in the File), I would need a display like “Run Query”. Once the user Runs the Query then count of Rows to be displayed on the same text box!

Looking forward your valuable suggestion for the same!

Thanks & Regards,
Rajeshkumar R

[isladogs]

I would suggest doing the following
1. use a label with a caption saying run query or similar.
2. add a button with code to run the query
3. when completed, disable the button, change the label caption to query results and show a hidden textbox with the result

[pbaldy]

Or you can use an IIf() function that tests the DCount(). If zero display your text, otherwise the count.

[RAJESHKUMAR R]

Dear Friends,

Thanks for your valuable suggestion! It works fine!

Thanks & Regards,
Rajeshkumar R

[pbaldy]

Glad you got it working.