form with no records

[Guest]

I have a form that is bounded to a union query and when there is no records
to display, all of the contorls (buttons, text boxes, list boxes, lables)
disappear. Does anyone know why its doing this and how it can be fixed?

 

[Rick B]

That is correct. When no records exist, that is what you will see on the
form.

 

[Guest]

If there are no records there is noting you can do but not opening the form.
'before running the openform command check if you have records in the query,
if no then give a message and dont open the form.