Printing Report If Conditions Exist

[labprof]

I have a form in my database that is used in my lab to report negative results in a analysis.
This form the tech will fill out certain fields if a condition exists.
A then have a report based on a query of the information on this form.
Here are my challenges.
I would like the report ~ for that particular record ~ to print if any field on the form has been filled out. Is there a way to make this happen when the form is closed?
So that the report automatically prints if a field is filled in on the form?

Any help with this is sincerly appreciated.

Labprof

 

[Remou]

I suppose you could set a global variable or a hidden control in the On Dirty event and check this variable or control in the close event of the form.

 

[dhookom]

I don't understand the question since forms don't contain data, they only display data. Tables contain data.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]