Close/Open form button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble linking a button to close the current form and saving all
data, then opening another form (i.e., main menu form). How do i do this?
 
davidpkohne said:
I am having trouble linking a button to close the current form and
saving all data, then opening another form (i.e., main menu form).
How do i do this?
Click to expand...


Me.Dirty = False
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "main menu form"
 
The following will close a form when placed in OnClick event of your button.
Docmd.close acForm,"NameOfYourForm"

This will open a form:
docmd.openform "NameOfYourForm"
 

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

register student to course 0
Opening form unexpectedly closes other form 0
Access Sub form opens before the main form in MS Access 0
Pop-up form that creates record that links 1:1 to main form 0
Sub-Form data entry 9
Prevent user to close tabbed form 2
Access how to open existing database from another database using Access - VBA 0
DMax on existing record to increment serialized # fails 1

Back
Top