PRevent Form from Closing?

[el zorro]

I have a form that allows the user to select the name of a person from a list
box, then click on a button to open a second form with the data for that
person. There is some VBA code for the On Close event of the second form that
updates the list on the first form. (.adp front end, back end on SQL Server)

However, if the user for some strange, unexplicable reason closes the first
form before closing the second form, Access generates an error message
saying, basically, "where the heck is the first form?" when the second form
is closed.

Isn't there a way to prevent the first form from being closed when the
second form is still open?

THanks!

 

[el zorro]

Thank you! I manually set the Modal property to "Yes," and it works great!

 

[erica nelson]

I have a form that allows the user to select the name of a person from a
list
box, then click on a button to open a second form with the data for that
person. There is some VBA code for the On Close event of the second form
that
updates the list on the first form. (.adp front end, back end on SQL
Server)

However, if the user for some strange, unexplicable reason closes the
first
form before closing the second form, Access generates an error message
saying, basically, "where the heck is the first form?" when the second
form
is closed.

Isn't there a way to prevent the first form from being closed when the
second form is still open?

THanks!
um hi