One Check box or Two

Discussion in 'Access Table Design' started by Cagney, Nov 23, 2010.

  1. Cagney

    Cagney Guest

    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, Nov 23, 2010
    1. Advertisements

  2. Cagney

    XPS350 Guest

    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.


    XPS350, Nov 23, 2010
    1. Advertisements

  3. Cagney

    Pat Hartman Guest

    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.
    Pat Hartman, Jan 3, 2011
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.