Close/Open form button

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?
 
R

Rick Brandt

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"
 
G

Guest

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
Access 2007 problem 2
Prevent user to close tabbed form 2
do not save data on subForm 5
Access how to open existing database from another database using Access - VBA 0
Pop-up form that creates record that links 1:1 to main form 0
Tabbing in Subform 3
How to add a button to a form that opens another form 7

Top