Query Combo Box (1 Viewer)

[stu_c]

Hi all,
how do I get a query to look for a value in Column 2 of a combo box?

 

[Ranman256]

in the AFTERUPDATE event of the combo, put that column value into a hidden text box.
Then the query can read the textbox.

'in VB , columns begin with zero, so column 2 is: cboBox.column(1)

sub cboBox_Afterupdate()
txtBox = cboBox.column(1)   
end sub

query:
select * from table where [field]=forms!fMyForm!txtBox