There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Tech Support Guy Forums > Members List >

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

hengameh hengameh is offline

Junior Member
Last Activity: 21-Jan-2009 12:01 PM

Visitor Messages

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
  1. OBP
    21-Jan-2009 12:13 PM
    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

About Me

Sorry, but to prevent spam, the profile of new members is hidden until they've made a few posts.

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 21-Jan-2009 12:01 PM
  • Join Date: 21-Jan-2009
  • Referrals: 0

Friends

Showing Friends 1 to 1 of 1
  • OBP
    • OBP
    • Distinguished Member
    • OBP is offline
Twitter Twitter! | Podcast | Mobile | Advertise
Contact Us - HelpOnThe.Net - Archive - Terms of Service - Top
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 12:51 PM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
 Powered by Cermak Technologies, Inc.