Combo Box Save for Later Use

[Guest]

I have a main table for my form. I am using 4 seprate lookup combo boxes for
my values. However when it stores those values from my look up tbls into my
main table, it stores the ID value and not the actual text from the lookup
table. How do I get the lookup value text to store and not the ID number into
my main table of my form?

 

[Rick Brandt]

I have a main table for my form. I am using 4 seprate lookup combo
boxes for my values. However when it stores those values from my look
up tbls into my main table, it stores the ID value and not the actual
text from the lookup table. How do I get the lookup value text to
store and not the ID number into my main table of my form?

The ID value is what you are supposed to store. If that is not what you
want then what purpose is the ID field serving?

There are lookup tables that are used to store actual text entries into
other tables with ComboBoxes and ListBoxes, but such tables would use the
text field as their Primary Key and would not have a numeric ID field.

It should always be the PK that is saved in other tables. If you want that
to be text, fine, but that would make an additional numeric key field
completely useless and redundant.

 

[Guest]

You should store the ID and not the description, what would happen if you
decide to change the description? in that case you'll have to update all
records.
Saving the ID will allow you to change the description only in once in the
table that holds the ID and description

*******************************
For future reference about the issue you have now,
If the Combo RowSource includes two fields
Select Id , Description From TableName

Then the BoundColumn property on the combo is set to 1, and this is why it
saves the first column. Changing it to 2 will save the second column

 

[Guest]

OK that makes sense now. Say I want to show that value from the main table in
another form. I dont want the ID to show but the actual text (saved value).
Am I thinking of this correctly?

 

[Guest]

In that case the RecordSource of this form should include both tables linked
between them using the ID field, that way you can display the description and
not the ID.
About creating a link between tables, check this link

http://www.databasedev.co.uk/query_joins.html