open and close form with one OnClick

  • Thread starter Thread starter Jeff @ CI
  • Start date Start date
J

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!
 
Jeff,
On the close button of form1st put this code

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

Jeanette Cunningham
 
Back
Top