P
Pele
Sometimes, based on the value entered in a textbox on the
mainform, a query linked to a subform will have no records
to return i.e. the subform is blank.
I need to run this subform in the Hidden mode so I can't
physically see situations where it does not have data.
Can anybody tell me how to identify the condition when a
query has no record, so that I can then use that decision
to launch a message box to the user that they need to
change the query filter they entered on the mainform.
Presently, the mainform is just a blank screen when no
records are available in the subform and the user won't
know what's going on. Thanks.
Pele
mainform, a query linked to a subform will have no records
to return i.e. the subform is blank.
I need to run this subform in the Hidden mode so I can't
physically see situations where it does not have data.
Can anybody tell me how to identify the condition when a
query has no record, so that I can then use that decision
to launch a message box to the user that they need to
change the query filter they entered on the mainform.
Presently, the mainform is just a blank screen when no
records are available in the subform and the user won't
know what's going on. Thanks.
Pele