Solved Open two forms forms at the same time but only have one visible?

[Puff]

Good afternoon all,

May I ask if it is possible to open two forms (frm_one & frm_two) at the same time but only have frm_one visible until a command button is pressed on that form.

frm_one (which is a pop up) frm_one should then be made invisible and frm_two made visible / editable.

Both of these forms are opened at the same time because a combo box query on frm_one is use to populate frm_two.

frm_one is physically smaller than frm_two and users could click outside of frm_one and cause me problems

A command button on my start screen opens both forms with the following code:

Private Sub EDIT_Click()
DoCmd.OpenForm "frm_one", acNormal, "", "", , acNormal
DoCmd.OpenForm "frm_two", acNormal, "", "", , acNormal
End Sub

Thank you

 

[MajP]

@Pufff
Your example is not correct in the windowmode argument there is no AcNormal. However there is a AcHidden which you can use to open a form hidden.

AcWindowMode enumeration (Access)

Access VBA reference

docs.microsoft.com

The default is acWINDOWNormal

 

[Puff]

Thanks for you answers guys