open and close form with one OnClick

[Jeff @ CI]

I would like to be able to open a form by clicking a button, once that form
is open and a variable is transferred, I would like to close the original
form. I have tried to embed a DoCmd.Close acForm "formname", into a
"OnClick" event procedure, but I still have the first form open. Need it in
2000 format.

Thanks for any help!

 

[Jeanette Cunningham]

Jeff,
On the close button of form1st put this code

DoCmd.OpenForm "form2nd",,,,,,"value of variable"
DoCmd.Close acForm, Me.Name

Jeanette Cunningham

 

[sebastico]

Jeannete

Thank you very much.
This code is what I been looking