DoMenuItem Issue?

[mkc80]

Hi I am trying to enter data via a form which has a save button when clicked should record this entry in the associated table.
(The record source for the form is the table).

The problem is, the form is saving only one record, and when I change the values on the form and hit save, it just overwrites the one record in the table.

Please advise

This is the code I have for save button:
Private Sub Command157_Click()
On Error GoTo Err_Command157_Click






DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


Exit_Command157_Click:
Exit Sub


Err_Command157_Click:
MsgBox Err.Description
Resume Exit_Command157_Click

End Sub

[June7]

Form is bound to the table. Data entry/edit is passed directly to the record in table. Data is committed when form is closed or loses focus, move to another record, or execute code. If either of the first two events happen, the third is unnecessary.

The following will commit the data entry/edit; however, the form focus is still on the record just created/edited:
DoCmd.RunCommand acCmdSaveRecord

If you don't want to overwrite values, need to move to a new (blank) record.
DoCmd.GoToRecord , , acNewRec