Conversation Between hengameh and OBP
IMPORTANT! READ THIS FIRST!This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to
the forums or read our
welcome guide for new members. Thanks for your cooperation!
Showing Visitor Messages 1 to 1 of 1
-
Hello hengamesh, I am afraid Queries only work with the first column of a combo, so create an Unbound Field on your form, you can set it's "Visible" property to No if you want to hide it.
Then in the After Update event of the Combo add
me.fieldname = me.combo.Column(3)
before the Requery statement, where fieldname is the actual name of your unbound field. Now in your Query us the Unbound Field as the Criteria.
Good luck
Tony
Welcome to Tech Support Guy! Read our Welcome Guide or take a minute to watch the video below!
