I’m a relative newbie at creating Access forms and I could not find an answer to his on the Access forums I usually reference. Here’s my question:
I’ve created a form that adds records to a table “DATA.” I want the user to select from a combo box the value “Y”, “N”, or “N/A.”
If the user selects “Y” I want the DATA record to have a 1; for “N” a zero, and for “N/A” a null value.
So I have another table, VALUES, that looks like this:
1 Y 1 2 N 0 3 N/A
In the combo box properties, I have Row Source = VALUES, Row Source Type = Table/Query and Bound Column = 3. For the formatting I have Column Count = 3 and Column Widths = 0;3;0.
This works fine for “Y” and “N” values - it populates my DATA table with the value of 1 or 0. And in fact if I select “N/A” it populates DATA with a null value. But…
The problem is in my form, if I select “N/A”, it disappears. It’s as if because the value of the field in DATA is now null, it’s not displaying a value in the combo box. I want it to show the “N/A” that the user selected.
Is there another way I should be doing it?