Combo Box Stored Value Field

[Dacsone]

How do you prevent the record number from lookup table
fields from being stored in the combo box stored value
field.

I can create the combo box with no problem, I select the
lookup table,fields and what field the select value should
be stored in. My problem is when I make a selection in the
combo box the fields record number is inserted into the
stored value field.

 

[Jeff Boyce]

Dacsone

If I've understood your situation correctly, that is EXACTLY what a combo
box is supposed to do. Are you saying that you don't want the ID# from your
lookup table to be stored? But that is what Access is good at -- relational
database structure.

 

[Rick Brandt]

How do you prevent the record number from lookup table
fields from being stored in the combo box stored value
field.

I can create the combo box with no problem, I select the
lookup table,fields and what field the select value should
be stored in. My problem is when I make a selection in the
combo box the fields record number is inserted into the
stored value field.

That is what *should* happen. The whole point of a lookup table with a
numeric key field in addition to a "user friendly" entry is so you can store
the ID and use lookups to *display* the text. That way if the text ever
needs to be modified, you do so only in the lookup table and all previous
records (where the ID was saved) do not need to be updated. They are now
simply *related* to the new text value.

If you have a lookup table where the entries are stable and you would prefer
to store the actual text (say a table of state abbreviations for example),
then the lookup table shouldn't even have an ID field.

 

[Marshall Barton]

How do you prevent the record number from lookup table
fields from being stored in the combo box stored value
field.

I can create the combo box with no problem, I select the
lookup table,fields and what field the select value should
be stored in. My problem is when I make a selection in the
combo box the fields record number is inserted into the
stored value field.

Maybe there's some confusion over what you mean by "record
number". If you mean the Key field in the lookup table,
then Jeff and Rick have explained what's supposed to happen.

If you mean you're getting the position of the record in the
list, then it's because you have specified 0 in the Bound
column property. Change it to the column you want to save
in the data field.

 

[Dacsone]

To all,

Thanks for your help, my issue is resolved.