Saving keys

[wop0703]

I have a form in which a user uses multiple combo boxes to choose certain items. each item in the combo box has a key attached to it in the table that the form was created from. I would like to save the appropriate key on my form next to the combo box. If this is possible, how do I go about doing this?

Thanks.

 

[jet46]

Make sure that the key is included in the row source of your combo box and then just create a text box next to it and set it's control source to "=ComboBox" (where combobox is the name of your combo box).

 

[wop0703]

the key is included in my row source but when I do what you say, I just get the description in thetext box and not the key. I would like to see the key only in the text box.

 

[jet46]

There are two ways to fix that. In the combo box's data tab, change the "Bound To Column" property to the column in which you ID is stored.

The second way to do this is to set the text box control source to:

=ComboBox.Column(ColumnNumber)

ColumnNumber would be the correct column number in your combo box. Use the
Column(CoulmNumber) function you can access data from any column in the combo box.