Pop up in MS Access

[amlcu2008]

Dear Collegues
I cant find a group for MS Access any way,i want to display an alert like the one in .net inside VBA in MS Access this alert asks the user if he would like to save the recorde or not if the user press yes we (Commit) if no undo changes.Please if any one know hot to make this code by visual basic subit it to me.Thanks

[Randoz]

Try this, I just don't know how to detect if there were changes made prior to running this, so that it won't happen if there were no changes.

Dim intButtonPressed As Integer
intButtonPressed = MsgBox("Save Changes?", vbYesNo, "Save")
If inButtonPressed = 7 Then
MsgBox ("Changes to record were not saved.", , "Record Not Saved!")
Me.Undo
Else
MsgBox ("Your record has been saved.")
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,, acMenuVer 70
End If

[Motoma]

I have moved this thread to the Access forum, with the hopes that the Experts there will have more information for you.