Lock a perant form

[sonja_n00b]

I have a form that opens another form...
When that other form is open the perant form must be disabled. How do I do that?! And when the form closes the perant form must be enabled again! Can anybody tell me?

 

[KenHigg]

Make the second form modal?

kh

 

[sonja_n00b]

Make the second form modal?

kh

underneath what property is that possible?

 

[Ron_dK]

The easy way out here is :

make a button on your "main" form
click this button to open a second form.
On the second form write a code docmd.maximize
this will open the 2nd form completely and will cover the main form.
On the 2nd form put a button to close it et voila your back at the main form.

Cheers, Ron

 

[sonja_n00b]

The easy way out here is :

make a button on your "main" form
click this button to open a second form.
On the second form write a code docmd.maximize
this will open the 2nd form completely and will cover the main form.
On the 2nd form put a button to close it et voila your back at the main form.

Cheers, Ron

Tnx but that is not really a great option for my form.

 

[KenHigg]

All forms have a 'Modal' property you can set in the properties window...


kh

 

[Ron_dK]

Set the property of the second form to Pop up and ensure that there is a close button on it.

 

[Mile-O]

On the first form.

Me.Visible = False
DoCmd.OpenForm "SecondForm"

On the second form:

DoCmd.Close Me.Name
Forms("FirstForm").Visible = True

 

[sonja_n00b]

Set the property of the second form to Pop up and ensure that there is a close button on it.

Something like this?

DoCmd.OpenForm "frm_log", acNormal, "", "log_id=" & List0.Column(0), acFormEdit, Modal

 

[KenHigg]

No - Just set it in form design view.

kh