In the BeforeUpdaate event on a form, I have a message box that prompts the user to confirm that they want to save the record. If vbYesNo = yes, the record saves properly but after the record is saved the form moves to the first record. How can this be coded so that the form stays on the current record that was just saved?
Any assistance is greatly appreciated.
Any assistance is greatly appreciated.