S stu_c Registered User. Local time Today, 14:30 Joined Sep 20, 2007 Messages 494 May 26, 2022 #1 Hi all, how do I get a query to look for a value in Column 2 of a combo box?
Ranman256 Well-known member Local time Today, 09:30 Joined Apr 9, 2015 Messages 4,354 May 26, 2022 #2 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) Code: sub cboBox_Afterupdate() txtBox = cboBox.column(1) end sub query: select * from table where [field]=forms!fMyForm!txtBox
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) Code: sub cboBox_Afterupdate() txtBox = cboBox.column(1) end sub query: select * from table where [field]=forms!fMyForm!txtBox