Combo Box

[James007]

I have question pertaining to combo boxes.
I have the control Source as ITEMID
my row source is ItemID;ManufactureID;Description
it is bound column(0) (i have changed this around to 1, and 2, and 3)

what i would like this combo box to do is display and search through the itemid but display when it is chosen the ProductID and record the value of the ItemID field.
Can this be done.
I have messed around with the Row sources but it doesn't display the ManufactureID

:banghead:

Your help is appreciated.

 

[Pat Hartman]

I don't see ProductID in your list of columns. If it is in a different table, create a query that joins the item table to the product table so you can select columns from both tables. If you use the wizard to create the combo, it will help you hide/show columns. If you do it yourself, you will need to work with the following properties.

BoundColumn - this defines the column that uniquely identifies a row and is the value that will be saved.
ColumnCount - the number of columns in the RowSource query.
ColumnWidths - a value for each column in the RowSource query that specifies the width. 0 width columns are hidden.
ListWidth - if you have more than a couple of columns, you may need to adjust this so that all the columns show when the combo is dropped down.