Form with Message Box

K

Kirk P.

I've got a form that opens in "Filtered" mode with this code:

DoCmd.RunCommand acCmdFilterByForm

I then have a message box that pops during the Form Filter event that says
"Select filter criteria and click Apply Filter button"

Problem is, the message box opens first, then the form. I want the form to
open first in "filtered" mode, with the message box on top of this form.
Help?
 
K

Kirk P.

Your question actually answered my question. I put the MsgBox in the
Form.Load event, and it seems to work as expected.

Thanks.
 
Top