Actually, I am afraid it wont work as I hoped. The way the form is set up is to look like a tabbed folder. The tabs are labels are in the form header and depending on which you click, displays different subforms. Therefore, I can't set the "empty query" label to visible if I am setting the form no not visible. I suppose I may be able to work something into the label's click event.
Here is the parent form On Open event...
Erik Pen
Last Activity: Dec 25 '10, 11:59 AM
Joined: Dec 22 '10
Location:
-
Thanks. I was trying exactly that (label in the header of the subform - except that I was trying the on open of the sub form. The IsNull never worked, i.e. it displayed whether null or not. I will try on the parent form.
thanks for your help. It is a bit more complicated because when my main form opens, it displays some sub forms while hiding others based on the tag property of the subform. I guess I can try to work this in as...Leave a comment:
-
Hi mshmyob
The subforms are continuous forms with headers.
Any help is appreaciated!Leave a comment:
-
Anyone? It really can't be that hard?Leave a comment:
-
Display message on subform when underlying query is empty
My main form has several subforms which display the results of queries.
I want to display a message in a subform when it's query is empty indicating that there are no records meeting the form's criteria.
wondering how this can be done.
Thanks
Erik
No activity results to display
Leave a comment: