How to freeze a form?

[ghost]

Greeting,
I have a form that contains many txtbox and combo boxes. In this form there
is a commend button to open another form. The problem is, the user can click
on the back form (main form) and it come forward and the other form goes
back. What I want to do is, once the user open the sub form, the user can not
click on the backward form (main form) unless he closes the foreword form.
How can I do that?
thanks

 

[Brendan Reynolds]

Greeting,
I have a form that contains many txtbox and combo boxes. In this form
there
is a commend button to open another form. The problem is, the user can
click
on the back form (main form) and it come forward and the other form goes
back. What I want to do is, once the user open the sub form, the user can
not
click on the backward form (main form) unless he closes the foreword form.
How can I do that?
thanks

Set the WindowMode argument of the OpenForm method to acDialog as in the
following example ...

Private Sub cmdTest2_Click()
DoCmd.OpenForm "frmTest2", , , , , acDialog
End Sub