Dear All,
Can anyone tell me how on exit of a field I can prompt the user via a message box the following:
TEXT IN CAPITALS = Functionality required

OnExit
ifisnull(startdate) then setfocus to next field
else
msgbox vbyesnocancel
The date you have entered will be stored permanantly, please select Yes to continue(IF YES DATE IS STORED AND FIELD IS LOCKED) or select no to change date(IF NO FIELD CAN BE EDITED BUT ONLY THE FIRST TIME THE FIELD IS POPULATED)or if cancel (CLOSE FORM AND CONTENTS OF DATE FIELD)

Thanks
Mark

Please don't post the same question under multiple topics.

Sorry, will not do it again