How to create a command that will save and close a form automatically

  • Thread starter Thread starter Sib
  • Start date Start date
S

Sib

I am trying to get a command button on the form to
automatically save and then close the form once I have
entered the data and then tab to that command button (on
the exit portion of the tab). I can get it created but
can't seem to figure out how to get it to close the form
after I tab off of the command. Basically I want to be
able to enter the data in the form and then once done be
able to have the form close with the next tab button,
without going to another blank version of the form.
 
Sib said:
I am trying to get a command button on the form to
automatically save and then close the form once I have
entered the data and then tab to that command button (on
the exit portion of the tab). I can get it created but
can't seem to figure out how to get it to close the form
after I tab off of the command. Basically I want to be
able to enter the data in the form and then once done be
able to have the form close with the next tab button,
without going to another blank version of the form.
Click to expand...


DoCmd.CLOSE
 
Tried the command DoCmd.Close but does not work with the
form. Says invalid code for use within form. :(
 
You must log in or register to reply here.

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

Access Automatically Send a notification email once a record is added 0
Closing a form 1
How to use multiple command button to copy user form data to multiple worksheet 0
Undo Auto Save on Close Form 15
Close Form After Clicking on command button 1
Saving a record in subform 5
Opening form unexpectedly closes other form 0
command button for save 1

Back
Top