I added this to the end of the line of code...
DoCmd.OpenForm "frm_Contract_Start_Date", , , , , acDialog
MsgBox Contract_Start_Date 'Added this just to test
And the MsgBox is still appearing at the same time the form is appearing. Have I missed something ?