Values in a Lookup Wizard

dxqwest

Registered User.
Local time
Today, 10:28
Joined
Aug 21, 2001
Messages
13
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.
 

Users who are viewing this thread

Back
Top Bottom