Basic Comman Button Question

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
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.
 
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
 
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
 
Back
Top