Using Check boxes for data entry

REDaughdril

Registered User.
Local time
Today, 06:31
Joined
Jan 23, 2000
Messages
58
Is there a way to use check box to enter data.
I have set up a yes/no format and change the format to "" (for not checked)and "Red" (for the checked).

Is there an easier way to do this?

What I would like, is to check boxes and have it enter the label as its value

[ ] Red
[ ] Blue
[ ] Green
[X] Yellow

Yellow would be entered in the data field under color in a color table.

I think I'm making this way to hard.

Thanks Rob
 
Create an Option Group using the Wizard and add the check boxes you want. Access will name the Option Group Framex where x is a number. In the After Update event of the Frame put code like this:

Select Case Framex
Case 1
Me.MyText = "Red"
Case 2
Me.MyText = "Blue"
End Select

Replace the x above with the actual number that Access gives your Option Group and change MyText to the name of the text control on your form.

hth,
Jack
 
Found this post using a search to answer my question about storing the label as the check box's value in a table. It's working for me except the check boxes are no longer "functioning" properly. When I select one of the check boxes on my form, it remains "greyed out" while the others clear rather than putting a check mark in the box. I changed the boxes to option buttons just to try it and the same thing happens. Would appreciate any help with this.
 

Users who are viewing this thread

Back
Top Bottom