Combo Box

[Parra]

I have a combo box on a form, I created it with the wizard to add the chosen item in a field of a table, but it add the ID# instead not the actual data.

How can I have it store the data and not the ID#?

Thanks

 

[SydneyGeek]

As a rule, combos always store the ID. This is necessary for data integrity later on -- if you have 2 clients with the same name, the ID will differentiate them.
Because of this I always use an ID field for storage of Combo data -- typically Long Integer, if you use AutoNumber. I then use combos on my reports to put whatever descriptive text I need for the report.
However, if you really want to store a non-ID value, you can change the BoundColumn property of the combo from 1 (the ID) to another field.

Denis

 

[Parra]

SydneyGeek You are the man!!!

Thanks.