Writing the 2nd column of a combo box to a table

S

sushi155

Hello I have a quick question. I have a combo box bound to a table tha
grabs two columns, Product name and Product ID. I have hidden th
Product ID column on the combo box.

When the users selects the Product name,fills out a few other fields
and hits add, I want only the Product ID and other fields (and NOT th
product name) written to a new table. I'm having problems because th
combo box is already bound to the first table that i got the info from
Any ideas
 
S

sushi155

Is this column property on the table I obtain info from or the for
itself or is it within the combo box
 
J

John Vinson

Is this column property on the table I obtain info from or the form
itself or is it within the combo box?
Click to expand...

It's a property of the Combo Box.

In VBA code you can retrieve the contents of the third column of a
combo box using the syntax

strGetIt = cboMyCombo.Column(2)

Note the 2 for the third column - it's zero based.

John W. Vinson[MVP]
 
Top