Help with a combo box

[EAB1977]

Hi everyone,

I am working on a database that will house our print data for our
facility. Our print ID is a unique seven digit number followed by the
print description. My field is bound by the print ID. When my drop
down box is activated, I have my print ID and my print description.

My question is can I have my combo box bound to the print ID and have
the print name displayed in the combo box?

 

[boblarson]

If your print name is in a separate field, I would just select both the ID
and the print name in the query for the combo rowsource and then change the
number of columns property to 2 and the column widths property to 0";1.5" so
you can see the second column(print name) but the first column (ID) is not
viewed.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________