When using more than one column in a combo box will a query be able to recognize both columns as a value or just one?

Just the bound column but you can, with code, add other data from the combo box to hidden fields on the form that the query can reference for additional criteria. Something like Me.HiddenField = Me.ComboBox.Column(1) in the After update event of the combo box should do it for you.