hengameh
Last Activity:
Jan 21, 2009
Joined:
Jan 21, 2009
Messages:
0
Likes Received:
0
Trophy Points:
0

Following 1

  1. OBP

Followers 1

  1. OBP

hengameh

hengameh was last seen:
Jan 21, 2009
    1. OBP
      OBP
      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
  • Loading...
  • Loading...