Combo box displayed value

J

Jac Tremblay

Hi,
I have a 2 columns combo box, the first being the ProductTypeId and the
second, the DescriptionProductType. This combo takes its values from the
table tblProductType. It is an unbound field.
On my form, I have a bounded field ProductTypeId that I populate through the
selection from the combo box.
In the combo, the Bound column is 1 and when both column are displayed,
there is no problem with the selection. But if I hide the 1st column (width =
0), then I get a data type error (the description is trying to populate a
numeric id field.
My question is: is there any way to display only the description and use the
hidden column value (the ID) to populate the textbox field?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top