Hi
I have a procedure which creates a new contract for an employee in the Contracts table (tbl_Contracts)
After some fields have been set a form appears in which the user will enter the Start Date of the new contract. This is done by the code...
The problem is, the code AFTER the DoCmd line is then executed but I don't want it to. I want it to wait until a date has been passed from the form that is opened.
How would I pause the code there to make it wait for the date to be entered ?
Thank you in advance.
I have a procedure which creates a new contract for an employee in the Contracts table (tbl_Contracts)
After some fields have been set a form appears in which the user will enter the Start Date of the new contract. This is done by the code...
Code:
DoCmd.OpenForm "frm_Contract_Start_Date"
more code here that works out the End Date based on the duration of the contract
The problem is, the code AFTER the DoCmd line is then executed but I don't want it to. I want it to wait until a date has been passed from the form that is opened.
How would I pause the code there to make it wait for the date to be entered ?
Thank you in advance.