ID Numbers reflected in table instead of the values choosen in form

[mebetheman]

Example: (my table)
ID | OS |
1 |Win 95 |
2 |Win 98 |
3 |Win 2000 |
4 |Win XP |
I have a form woth values in combo boxes, I choose a value and in my table for some reason the value that gets entered in is the value that is my ID field nto the value in the Combo box I choose. It is it's corresponding ID number, bizzarre, anyone, anyone?

 

[JeremyNYC]

Nothing bizzare here at all. This is what' supposed to happen.

You should have two tables.

One table should be like the one you quoted from in your post, which is a lookup table. This table should be the rowsource of your combobox (which should be bound to the first column, which should have a width of zero).

The other table should store a bunch of stuff, including a field for the OS. Except you won't store the OS, you'll store the OSID.

This will keep you from storing any bogus values, will keep people from storing typos, and will save a tiny bit of storage space.

Hope this helps.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.