Forms in Access 2003

[EST7745]

I'm attempting to make a form that will input data in to a table. I have a combo box that gives the user a pulldown box of info that they can chose from. However, regardless of what they chose, it always shows up as "1" in the table. For example, if their choices in the combo box were Yes or No, if they chose yes, it would appear as 1 in the table and if they chose no it would show up as 2 in the table. Can anyone explain what is happening? We are running Access 2003

 

[fneily]

Frist, post Access questions in one of the six Access forums. You would post in Microsoft: Access Forms.
On your form, in design view, you will create an UNBOUND combobox. Bring up the property sheet (the button with the hand holding a piece of paper). Click on the combobox. On the combobox's property sheet, change "Row Source Type" to List Value.
Next to "Row Source" type yes;no
Click next to Control Source, click the drop down arrow and select the fieldname to store the answer.
Most, if not all, Access programmers use a yes/no control.

You are storing the index of the combobox.

And, since it seems like you're new to Access, you might consider that you can't learn Access on your own. I suggest taking courses.

Also, if you didn't NORMALIZE your tables, your database is constructed wrong. No ands, ifs or buts. It's not correct.