I am working in an ADP. Since I had a hard time customizing MsgBox interaction with a user(ex: making text bold), I followed some advice and created forms I call in lieu of a MsgBox. Primarily I use the Forms to validate new record entries made by a user before a complete entry is recorded in the database. When the user hits the 'Record Entry' button, I pop up a form to have the user double-check entries they were allowed to enter as free text.
If the user selects 'No', the entries are not correct and I redirect the user back to the last Form control where they entered data. This works. If the user selects 'Yes', I want the program to move through the additional lines of code in the RecordEntry module.
The problem I am running into is that once I pop up the form with the DoCmd.OpenForm funtion, the rest of the RecordEntry code continues to run in the background. How can I pause the program while I allow the Form to run?
If the user selects 'No', the entries are not correct and I redirect the user back to the last Form control where they entered data. This works. If the user selects 'Yes', I want the program to move through the additional lines of code in the RecordEntry module.
The problem I am running into is that once I pop up the form with the DoCmd.OpenForm funtion, the rest of the RecordEntry code continues to run in the background. How can I pause the program while I allow the Form to run?
