Combo box linked to unbound field

[JSDART]

I've done this before but it is escaping me now any help would be appreciated.

I have a combo Box that looks up activity code and activity desc it then saves the code on the form.
What I want to do is then have an unbound field on the form that displays the description so the users sees both code and description on the form and it only requires the user to choose the code number from the combo box.

thanks

 

[a.sinatra]

What you could do is setup a description field in your table and use it as a memo, but you could use case statements to call the description, but it wouldnt be that efficent (example: if you added new products you would have to add another case statement.)
________
Extreme q vaporizer

 

[dcx693]

If your combo box has the activity code and it has the activity description as you say, then you can easily display the description in an unbound field on your form.

Use the .Column property of the combo box like this:
Me.UnboundField=Me.cboActivity.Column(1)

If you have a single column combo box, then Me.combobox is the same as saying Me.combobox(0). The column numbers begin at 0. If you feed your combo box with a query, hide the second column, then you can just use code to show the results in other fields on your form.

 

[JSDART]

Thannks

Thanks DCX693
I was able to attach that code to the exit of the code number and it poputated the unbound perfectly
thanks again
J