I am using a macro to open a form for data entry with a criteria of machine number as "where" condition. The main form is based on a query and there are several related subforms all relating to the machine number. The problem I am having is that, if there is no data entered in the table for that machine number, I get a big blank screen. How do I get the form NOT to open when the query returns nothing for that machine number?

D'OH! I solved my problem for now, I just moved the "Close Form" button into the form header so it shows up now. Now, if nothing is scheduled to run on that machine, and the form is opened, at least they can get out of it. I would still like to know how to stop the form from opening in the first place.

Is this main form open by yet another form before it? If so, disable the button that opens it if there are no records to view.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yes, it is opened from another form. I'm not sure how to disable the button that way though. Do I somehow do it in the properties for the button or for the form??

On the calling form's ON CURRENT event, see what the record ID is. Then use a DCOUNT function to count how many records in the called form's record source match that ID. If the DCOUNT is zero, disable the OPEN FORM button, otherwise enable the button.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division