Form Opens as a blank

[tmartin]

I have a search form that uses an Option Group, text boxes and a checkbox to gather information from the user that is used in a query for information.


If I do a query and there are no results (Docmd.OpenForm(,,MyQuery,,)) , the split form windows opens as blank and the controls that I incorporated on the form(Edit and Close) are not visible.
So I thought well maybe I should do a DLookup first to determine if a query returns null thereby returning control to the search form highlighting that no records were found. If the DLookup was not null then proceed with the DoCmd.OpenForm command.

I am a novice to Access. Is there another way to resolve this problem?

Tom

[tmartin]

Resolved the issue by using
if DCount ("*","QueryName". Criteria) > 0
If the count > 0, then go execute the DoCmd.OpenForm command

[Missinglinq]

That's what I was just getting ready to suggest! As to the why...if a Form has no Records and New Records cannot be added (for whatever reason) the Form opens with nothing showing, not even the Controls, themselves!

Linq ;0)>