Check box validaion question (basic question)

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi guys,

I know this is probably a very basic question. but I
have different forms for users entering data and at the
bottom of each form is a checkbox asking

"please check if all information entered is correct."

What I need to do is when the user presses add record,
he/she will not be allowed to move to the next blank
record unless this checkbox has been checked....

having it as "required" does not seem to work as no is
the default option and as so is filled in....

Any help much appreciated.
paul
 
Hi Paul,

try using this code in your Form Before Update Event:

if NOT me.yourcheckbox then
msgbox "NOT COMPLETE"
Cancel=true
end if

Hope this help.

----- paul wrote: -----

Hi guys,

I know this is probably a very basic question. but I
have different forms for users entering data and at the
bottom of each form is a checkbox asking

"please check if all information entered is correct."

What I need to do is when the user presses add record,
he/she will not be allowed to move to the next blank
record unless this checkbox has been checked....

having it as "required" does not seem to work as no is
the default option and as so is filled in....

Any help much appreciated.
paul
 
Back
Top