Hello AccessWorld Family,
I need your help :banghead:
I created a SaveRecord button using the wizard. Currently, the SaveRecord do not notify the user that the record was actually saved in the table. Upon clicking the SaveRecord button, I want a confirmation message that tells the user “Record Saved”. In Design View, I click on the SaveRecord button, property sheet On Click Embedded Macro says,
OnError
Go to Next
Macro Name
RunMenuCommand
Command SaveRecord
If [MacroError] <>0 Then
MessageBox
Message = [MacroError].[Description]
Beep Yes
Type None
Title
End If
Does this go into the code above or is it a separate code line:
MsgBox “Record Saved”, “Confirmation Message”
How do I modify this to return a confirmation receipt after saving a record in the table?
I need your help :banghead:
I created a SaveRecord button using the wizard. Currently, the SaveRecord do not notify the user that the record was actually saved in the table. Upon clicking the SaveRecord button, I want a confirmation message that tells the user “Record Saved”. In Design View, I click on the SaveRecord button, property sheet On Click Embedded Macro says,
OnError
Go to Next
Macro Name
RunMenuCommand
Command SaveRecord
If [MacroError] <>0 Then
MessageBox
Message = [MacroError].[Description]
Beep Yes
Type None
Title
End If
Does this go into the code above or is it a separate code line:
MsgBox “Record Saved”, “Confirmation Message”
How do I modify this to return a confirmation receipt after saving a record in the table?
Last edited: