One Check box or Two

[Cagney]

I have a situation where I get information sent to me via email.
I have to verifiy that account info is Valid or Not Valid. So I have a
check box that the user clicks to confirm the status. Upon clicking
the checkbox I have code fill in 2 fields DateVerified and VerifiedBy.
My dilemma is when the account is NOT valid, the user simply does not
do anything, leaving the checkbox UNChecked. Therefore my code does
not fill in the fileds that indicate When and Who verified the
account. So I am thinking of adding a second check box called InValid
forcing the user to click only one box. This way if both boxes are
unchecked I then know that no one has verified these accounts yet.
Is there another way to handle this?
Thanks for the help.
Cagney

 

[XPS350]

I have a situation where I get information sent to me via email.
I have to verifiy that account info is Valid or Not Valid. So I have a
check box that the user clicks to confirm the status. Upon clicking
the checkbox I have code fill in 2 fields DateVerified and VerifiedBy.
My dilemma is when the account is NOT valid, the user simply does not
do anything, leaving the checkbox UNChecked. Therefore my code does
not fill in the fileds that indicate When and Who verified the
account. So I am thinking of adding a second check box called InValid
forcing the user to click only one box. This way if both boxes are
unchecked I then know that no one has verified these accounts yet.
Is there another way to handle this?
Thanks for the help.
Cagney

You could make one field with 2 (or 3) possible values: Valid, Unvalid
(if you want Unchecked). When the value of the field is changed to
Valid or Unvalid, you fill the other fields.

Groeten,

Peter
http://access.xps350.com

 

[Pat Hartman]

Rather than creating a second checkbox, you could replace the first with an option group with two options. The option group can be designed to show checkboxes or radio buttons which ever looks best to you. Your code looks at the option group itself rather than the individual options. The options must be numeric and unless you have some objection,the first option should be 1 and the second should be 2. If the option group control = 1 then the first option was check, otherwise, the second (or neither) option was checked.