Opening a form with a button on an open form

[Rich J]

I am updating an existing database. On most of the existing forms the
previous person put a button to open another form next to the combobox that
is used to select the name of the author of the document. When the button is
pressed the form Engrs opens on top of the existing form so that a new name
can be added to the list. When I change the name in the code to the new
form, it opens but is hidden by the existing form.
I can't find the differences in the properties to have the new form open on
top. There is nothing in the existing VBA code that does this either. When
I minimize the first form the new form is visible and works correctly.
Help please. Thanks

 

[Geof Wyght]

Rich,
There are two things you could do:
1) In the 1st form, in the button click event add
Me.Visible=False
Then in the close event of the 2nd form:
DoCmd.Openform "form1"
2) check out the popup and modal properties of the 2nd
form. Set them to yes.
Geof.

 

[Brendan Reynolds]

Perhaps they're using pop-up forms - check the pop-up property, which is the
first property on the 'Other' tab of the Properties window in form design
view.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Rich J]

Thank you both. I knew it had to be something so simple.

Changing the Pop Up to Yes did the trick. I missed that when comparing the
properties from the old form to my new one.