Blank forms when underlying query empty

[PhillipsAndrew]

This is probably the easiest thing to solve..

I have a form with its recordsource based on a query. However, when the query finds nothing the form opens totally blank.

All list boxes, text boxes and most importantly the close button disappear. I'd like it to display an empty list box together with all the other controls so the form can be closed in a consistent manner.

Any ideas?

Thanks

 

[Mile-O]

Then why open it at all if it has no data?

 

[PhillipsAndrew]

Thanks for the info...

I don't generally have a click event to open the form...

I bring up this form (A) with a list box displaying relevant records based on a query, using the list box click event a new form(B) is opened where the user can edit the record they've chosen.
If they choose to delete the record then when form(B) is closed it requeries form A to display updated data (using the OpenArgs parameter)
This works fine when there is more than one record, however, when the final record is deleted and form A is requeried I get a totally blank form!

I'll play with the info you gave in the link and see if I come up with something... I'm just on a deadline with this one,

Thanks again