Open & Close Form

[lawfour]

Hi I am working on a database and I was wondering if this is possible:

I created 2 forms each with buttons opening forms 1 & 2, is it possible to click on the open button in form 1, to open form 2 and at the same time closing form 1 using the same open button in form 1.

Pressing the same button to do two tasks, open and close.

Thanks

 

[Dugantrain]

Docmd.OpenForm "Form_2", acNormal
Docmd.Close AcForm "Form_1"

 

[Russell Hauf]

Welcome to the board. Not sure if I understand what you're saying. If you want to open form 2 from form 1, and then close form 1, then yes, you can try something like this:

Sub cmdOpenClose_Click()
    Docmd.OpenForm "frmTwo"
    Docmd.Close acForm, "frmOne"
End Sub

HTH,

Russell