Post reply

Access 2000 Does Not Search in Combo Boxes ???

  • July 9, 2005 at 9:03 am

    #76370

    I have a combo box ( dropdown list) on a form that lists clients from a lookup table, which are stored like this:

    pkClientID                 ClinetName

    1                          AAA
    2                          Ace Hardware
    and soforth.

    My combo box stores the IDs of the clients rather than the names

    In Access 2002 I can do a ctrl-F search inside this box no problem, with the 'Look in' property set to 'Client' (apparently this matches the label, and not the field name), and the Match property set to Any Part of Field.  If I search for "Ace" for example, it finds Ace Hardware no problem.

    In Access 2000 however, if I search for any text at all, with the 'Look in' property set to 'Client' it comes up with nothing.  I have to search for the ID number of the client to find it.  BUT, if I search for "Ace" with the with the 'Look in' property set to the entire database, then it finds "Ace", even in the combo box. 

    I could tell my client to always keep the 'Look in' property set to the entire database, but that is 1) ass-backwards, 2) not the default, 3) inconvenient, because the name of the client may also be embedded in the name of the Proejct, or the comments, and so they'd get several hits per record.

    Is there anyway around this, short of telling my client that he needs to buy 40 Office XP licences?

    Thanks.

    Aaron

  • July 11, 2005 at 3:54 pm

    #573160

    Is my question clearly presented? 

    Just to summarize even further:

    Access 2000 Combo boxes don't seem to be searchable, if the value stored in it is an ID number instead of text.  Access 2002 does not have this limitation.

    Anyone heard of this before, or know a workaround?

    Aaron

  • July 11, 2005 at 5:24 pm

    #573171

    I checked your question but I don't know what the problem is... waiting for feedback from other members.

    Also if you need ms access specific answer you might visit this site : http://www.AccessMonster.com

  • July 12, 2005 at 2:01 pm

    #573665

    Hi Remi,

    I posted it on Access Monster.  So far no responses.  I guess no one knows a solution to this issue.  Perhaps there is none.  It's just Access 2000 blew it on this feature.

    As a workaround I'm going to put a button right next to the combo box that says "Search" so that people will click it instead of using ctrl-F.  That will open up a custom form where I can do all my ADO searches, and display results using DoCmd's that act on the main form.

    Thanks.

    Aaron

  • July 12, 2005 at 2:10 pm

    #573668

    As long as it works...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply