Basic Comman Button Question

S

SITCFanTN

I've added a "Save Record" command button to my form, however when it is
clicked, it does not clear the form for a new record to be added. How can I
alter the VBA Code to save the record and clear the form for additonal data
entry? Thanks so much for your help.
 
L

Linq Adams via AccessMonster.com

Actually, if you go to a new record, the record you were on will
automatically be saved!

DoCmd.GoToRecord , , acNewRec

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
D

Dirk Goldgar

SITCFanTN said:
I've added a "Save Record" command button to my form, however when it is
clicked, it does not clear the form for a new record to be added. How can
I
alter the VBA Code to save the record and clear the form for additonal
data
entry? Thanks so much for your help.
Click to expand...


Assuming this button uses VBA code and not a macro, you can just add this
line:

RunCommand acCmdRecordsGoToNew
 

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

Clarification on 'Add New Record' Command Button 3
Access Automatically Send a notification email once a record is added 0
Macro doesn't work first time form is opened. 2
Me.Undo doesn't work, records are added each time i enter the form and exit 0
Data Entry Only 7
Error message 2950 when attempting to save a record 3
Restrict Data Entry 2
Button Label is invisable 2

Top