Combo Box values being stored in tables as 1 and 2 etc..

[Ron Wilson]

Hi,

I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...

 

[pbaldy]

Actually, it sounds like appropriate behavior. You store the key value, not the text value. For a report, you use a query that joins the 2 tables together on the key field.

 

[anthonys]

If you want to store the actual value you will need to change the "bound Column" property of the combo box. The datasource probably has 2 columns, column 1 is the ID and column 2 is the value you want to store. If you change the bound column to 2 it will store the description instead of the ID.

Hope this Helps

Ant