Combo-box different data entered than stored

[Voltron]

Here is what I am trying to do. I have several combo-boxes that are, at least for the moment, bound to controls on a form and bound to certain tables. I want to have the user open the combo-box and choose from a selection of text (words) that correspond to different areas of the organization.

The information that I have is stored in a 2 field table (Business_Segment_ID which is numeric and Description which is text based) that will remain that way. I have already gotten it to the point where both the Business_Segment_ID and Description are both shown in the combo-box. This was done by making the row source of the control equal to the Business_Segments_TBL that was created and changing the column count to 2.

However, I would like the information to be stored as the numerical Business_Segment_ID, but when the user chooses an option from the combo-box I want it to be the text based Description.

Is this possible? How?

 

[Kryst51]

If you use the combo box wizard, it will walk you through. you choose both fields for the box to look up, then sort by the descriptor, and it will hide the ID. Then later in the wizard you can pick where you want to store it. And it will store the ID, but display the descriptor.

 

[Voltron]

If you use the combo box wizard, it will walk you through. you choose both fields for the box to look up, then sort by the descriptor, and it will hide the ID. Then later in the wizard you can pick where you want to store it. And it will store the ID, but display the descriptor.

SWEET! Thanks for the advice. I will give that a shot.

 

[Kryst51]

Your Welcome. Please let us know if it worked! glad I could help.

 

[Voltron]

PERFECT!

Thank you so much. I was told to just use the autoform version at work so I did not even think to remake it using the wizard.

 

[Kryst51]

I am so glad it worked!

 

[Voltron]

Also, thanks to your help. I was able to use this knowledge to actually work backwards through the query that the wizard created so that I know how to run the queries myself now, saving time and allowing me to have the flexibility of changing controls in later iterations.

Thank you again very much.

 

[Kryst51]

Your Welcome again!