[Weezer]

Yes I know, wrong forum. However, I don't belong to any PC forums and I'm sure some of you have to use this at work. Here is what I want to do:

I need to create a form where users can input data that is then written to the table. I want to have questions such as these: Gender, with radio buttons for male, female. I will have fields in my table that are gender_male and gender_female. If they click male, it will print a 0 to female and 1 to male, and visa versa. I also want to have checkbox questions, in which they can click as many options as they want, similarly printing 0 and 1 as yes/no responses in their respective fields of the data table.

I can make checkbox and option button questions in the form wizard, but I cant figure out how to link each response to its own field in the table. All it lets me do in a multiple response question is assign a 1, 2, 3, 4 etc to each variable, and link that to one field of the table. Please help!

[CatOne]

c'mon, dude. Access doesn't even RUN on the Mac.

Maybe you could Join a windows forum :-P

[rickey939]

Interesting thread.

[El Gato]

Create your table first. When you specify the name of the fields in the table, you also set the properties (i.e. text, number, date, or yes/no). To do what you want, set the field property to 'yes/no'. Once the table is complete, then go to the form wizard and tell it to create the form based on your table.

Alternatively, if you create the form first, right-click on the radio button/checkbox and select 'properties -> control source' and then select the appropriate table and field that you want to link the widget to.

This is pretty basic stuff, you may want to pick up a book on designing Access DB's if you're doing this for work.