How do you refer to a query field programmaticaly? 1

[sera]

Hello,
I have created a command button that prints multiple reports. I pass the parameter to the query using forms![formname]![controlname]. I have four reports that are printed when the command button is clicked. Each report is driven by its own query, but they all use the same parameter. Sometimes there are only three reports that need to be printed....so the fourth report is printing blank. I need to check the value of the query(make sure it is not null) before I print the report, but for the life of me I don't know how? Thank you for your Help!
Sera

 

[Psychpt]

for the reports you don't want printed blank;

in the on no data create an event procedure:
Cancel = true

 

[sera]

That worked! How easy! Thank you!
Sera