One Check box or Two


C

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
 
Ad

Advertisements

X

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
 
Ad

Advertisements

P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top