Fornation where are you? (1 Viewer)

[mark curtis]

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

 

[Pat Hartman]

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

 

[mark curtis]

Sorry, will not do it again