Save record and open new record simultaneously

[germain2]

Is there a way to program the Save command to save a record and move forward to the next record at the same time? Thanks for your help

 

[Remou]

Which save command? Please post some code.

 

[germain2]

I am trying to use a command button at the end of a data entry form so that the person entering the data can save the record and move to entering the next set of data. Right now the system allows for saving the record but does not move to the next blank form. Hope this is clearer.

 

[Remou]

Are you referring to a single form, that is, not a datasheet or continuous form? What code is behind the command button?

 

[germain2]

Remou
I am attaching the Save record command button to a form that is single form with embedded continuous and single forms. The code for the command button is:
Private Sub Save_Record_Click()
On Error GoTo Err_Save_Record_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Save_Record_Click:
Exit Sub

Err_Save_Record_Click:
MsgBox Err.Description
Resume Exit_Save_Record_Click

End Sub

How do I get it to save as well as move to the next record.
Thanks

 

[PHV]

Like this ?

Private Sub Save_Record_Click()
  DoCmd.RunCommand acCmdSaveRecord
  DoCmd.RunCommand acCmdRecordsGoToNew
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886