How to go back to record edited?

[Song Su]

On my form before update event, some fields are not critical if left blank
so I allow user to save record (I do not put 'Cancel = True' ) and move on.

However, I want to display a reminder msgbox saying some fields left blank.

User might hit PageDown to move to different record. How to still display
the record user edited? I'm thinking about mark record number and go to that
record number but don't know how to do it.

 

[Rick Brandt]

On my form before update event, some fields are not critical if left
blank so I allow user to save record (I do not put 'Cancel = True' )
and move on.
However, I want to display a reminder msgbox saying some fields left
blank.
User might hit PageDown to move to different record. How to still
display the record user edited? I'm thinking about mark record number
and go to that record number but don't know how to do it.

Display the reminder with two choices for the user. Ok and Cancel. If they
press Ok then do nothing. If they press Cancel to indicate that they DO
want to fill in those blank fields then set the Cancel argument to true.
Since they never leave the record there is no need to send them back to it.