Novice needs help with Yes/No Msgbox in Access 07

[juliancasa]

My form is used for entering records in Access 2007.

When a user clicks a button to submit one, I want a pop-up box to load up
saying "Would you like to enter another record?" with Yes or No options
listed below. If yes, a new blank record loads up, if no, the form closes. My form and table are both called Hospitals.

How can I do this? (I am a bit of an Access novice so if you could be basic
in your answer - i.e. where to place code, etc. that would be great).

Thanks!

[missinglinq]

If this is a bound form, i.e. based on a table or query, the following will do the job nicely.

Private Sub YourSaveButton_Click()
If Reps = MsgBox("Would you like to enter another record?", vbYesNo) = vbYes Then
  DoCmd.GoToRecord , , acNewRec
Else
 If Me.Dirty Then Me.Dirty = False
 DoCmd.Close
End If
End Sub

If the form is bound, you don't need to do anything to save the record. Records on bound forms are automatically saved, in Access, when the user changes to another record or when the form is closed.

Welcome to Bytes!

Linq ;0)>