Solved Message when last record is saved (1 Viewer)

[Number11]

Is it possible to have a message box when the last record is reached and saved to say something like
"All Completed" - Job done!

 

[theDBguy]

On a form or a recordset? How is the user moving from one record to the next?

 

[Number11]

On a form or a recordset? How is the user moving from one record to the next?

oh yes its on a form user is clicking on a button to get next record

 

[theDBguy]

oh yes its on a form user is clicking on a button to get next record

What's the code behind the button to get the next record? Maybe we can just add to it.

 

[Number11]

What's the code behind the button to get the next record? Maybe we can just add to it.

its...
DoCmd.RunCommand (acCmdSaveRecord)
Me.Recordset.MoveNext

 

[theDBguy]

its...
DoCmd.RunCommand (acCmdSaveRecord)
Me.Recordset.MoveNext

Okay. My guess is you're asking this question because when the user finishes the last record, they're getting an error message, correct? If so, all you need to do is add an error handler to your code.

 

[Number11]

Okay. My guess is you're asking this question because when the user finishes the last record, they're getting an error message, correct? If so, all you need to do is add an error handler to your code.

yes thats correct but i do what to also show a message so they know all records have been completed

 

[theDBguy]

yes thats correct but i do what to also show a message so they know all records have been completed

Yes, that's what you would do in the error handler, show your own message. Now, could you please remind me what the error number is when they hit the last record?