Combo Boxes!

[marclf]

Hi,

Im currently creating a database for the company i work for.. Im a
complete novice when it comes to Access, having had barely any
experience with it.

Ive found myself in a bit of a pickle! I need to display a series of
products that my company use. I have 2 separate tables for this
information. InputMedia and OutputMedia (as we copy data from various
forms to others) however when i make a form and try to display this
information in a combo box i get the InputMediaID values showing
instead of the ProductCodes that i want to display. As i scroll through
the records the right product codes show, its only when i open the
combo box.. HELP! ive been driving myself crazy over this hehe

Regards,

Marc F.

 

[Katrina]

It shows the ID because the ID is the first value in the combo box source.
In your properties for your combo box, make the column width of the first
field 0.

HTH
Katrina

 

[marclf]

omg katrina i love you!! hehe thank alot its much appreciated you saved
my sanity, cant believe it was something as simple as that hehe

Thanks again!

MarcF.