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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close popup form from a continuous subform 3
form objects lose association with VBA code.. 2
Close pop-up forms efficiently 3
Access Open Form with WhereCondition 6
Always asks to "Save Changes" to Form Design in Access 2007 1
How to interrupt a form close? 5
Opening form unexpectedly closes other form 0
Close One Open Another 7

Back
Top