Pop Up Forms

[tbd]

How do I set up a pop-up form that opens when I open my
database? I have set the Pop Up option to YES in the
forms properties, but I need to build the event procedure
and I am not sure how to do it? Can anyone help?

Thanks in advance!

 

[Allen Browne]

Specify the WindowMode when you OpenForm, like this:
DoCmd.OpenForm "MyDialogForm", WindowMode:=acDialog

 

[tbd]

Hi Allen,

Again, thank you for your help on this. I have tried this
below, but with no success. I have added this line of
code in the Event Procedure on Open, but when I close the
Database down and then re-open it, the form still does not
pop-up automatically. What am I doing wrong?

 

[Rick Brandt]

Hi Allen,

Again, thank you for your help on this. I have tried this
below, but with no success. I have added this line of
code in the Event Procedure on Open, but when I close the
Database down and then re-open it, the form still does not
pop-up automatically. What am I doing wrong?

The popup property has nothing to with a form opening automatically at
startup. That simply caused the form to "stay in front" of all other
objects when it is opened. If you go to Tools - Startup on the main menu
you can specify the name of a form that you want to open automatically when
the file is opened.

 

[Tbd]

Thank you very much Rick!

-----Original Message-----


The popup property has nothing to with a form opening automatically at
startup. That simply caused the form to "stay in front" of all other
objects when it is opened. If you go to Tools - Startup on the main menu
you can specify the name of a form that you want to open automatically when
the file is opened.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.