Access Form Combo Box??? 1

[Skins64]

I have a table called ItemOrders, it has ItemID ItemName and ContactID. I built a form with a drop down box so that data entry can be done by selecting which item has been ordered, I need to be selecting the ItemID, BUT I need the ItemName to show in the drop box for data entry, how do I make it happen?

Thanks in advance!!

 

[PHV]

Have you tried to follow the combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MrKABC]

I don't know if you have already solved your problem, but here's my $0.02...

All you need to do is set up your combo box with two columns, column one with ItemID and column two with ItemName.

Then set your Properties, Format, Column Count to 2, and your Column Widths to 0";1" and be sure that under Data your Bound Column is set to 1.

(note that 1" is an arbitrary width I came up with, you can make it whatever width you need to accomodate your descriptions.)

That should do the trick!