Different Values in Drop Down Menu and Data Table

[colourxpalette]

Hi all! I'm new to Access, and was hoping I could find some help here. Sorry if some of my terms aren't the correct ones; I'm still trying to figure everything out.

I want to create a drop-down menu, with the selections "NA", "No", and "Yes". When these values are selected though, I want the data table to code these answers as numbers. Ex, if I selected "NA", I want the table to show the value "0". Is that possible/how can I do this?



Thank you!

[Bob Fitz]

You talk about a "Drop Down Menu" but I suspect you actually mean a "Combo Box". The attached db shows how you might use a combo box to save numeric values to a table after selecting a text value. Take a look at Form1, which is used to Add/Edit data in Table1.

[colourxpalette]

Yes, I meant a combo box, thanks.

I tried to replicate what you did up there; however I think I'm still missing some things. I don't know where to define my values. In the Row Source for the combo box, I put in "0;NA;1;No;2;Yes", but then it shows up as 6 options in the combo box (as opposed to just NA, No, or Yes). I tried to copy your property sheet exactly, and also put in the code for the event procedure after the combo box updates. I must be missing some things but I'm not sure as to what. Do you have any idea what that may be, or is that too vague?

By the way thank you very much for your speedy answer; I really appreciate your help!

[Bob Fitz]

take a look at the Column Count property of the combo box.

[colourxpalette]

Wow that was silly.
Thank you, it works perfectly now!!