Throwing msg before form is visible

[Guest]

I have a form that applies a filter in the onOpen event. If no records are
found that match the selection criteria I want to throw a message that
explains why the user is now looking at a blank form.

I've tried several different events but not matter what I do the message
keeps getting thrown before the form is visible. I've also tried setting a
switch and keeping off a control other than the form itself (ie, the command
button that gets focus onOpen). Still no dice.

How can I do this?

 

[Allen Browne]

Try adding this line to force Access to show the form:

Me.Visible = True

 

[Guest]

once again - bingo! - you are the best.

Try adding this line to force Access to show the form:

Me.Visible = True