Results 1 to 5 of 5

Thread: Combo - Seach

  1. #1
    Join Date
    Mar 2004
    Posts
    27

    Red face Unanswered: Combo - Seach

    Hello,

    Does anybody knows how I can use a combo to search?
    I was using a parameter on the query so that I could select the data I want. But I was asked to do that using the combo, for example, I select the name of a person and all her data is displayed...

    TkS!

    Atha
    Atha
    20175337

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Hi Atha,

    Assuming you have a form already designed you eliminate the Parameter in your query. In Form/DesignView Click on the ToolBox (Click to turn on your Wizards)and Click on the ComboBox button. Click on your form where you want that to be placed and follow the wizards. Choose the FirstSelection (I want the Combo Box to look up the values....) Click NEXT. Click to Queries OptionButton. Click NEXT and Select the Field you want to pull the data from. (this being the field you initially had the Parameter set in). Click NEXT and the NEXT, then select the OptionButton for (remember the value for later use). Click NEXT, name your ComboBox and Click finish and you're done.

    give it a whirl and if you have problems come back and will try to assist further.

    Bud

  3. #3
    Join Date
    Mar 2004
    Posts
    27

    Combo - Search

    Bud...

    I followed your instructions... The combo works... But the other controls don't follow what I select on this combo...
    What Am I missing??

    Atha
    Atha
    20175337

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by atha
    Bud...

    I followed your instructions... The combo works... But the other controls don't follow what I select on this combo...
    What Am I missing??

    Atha
    Hi again Atha,

    If you could Zip and Post your database I will take a look at it and see if I can fix it for you. Or make a dummy copy of it and post.

    Bud

  5. #5
    Join Date
    Mar 2004
    Posts
    27

    Red face

    Let's try then Bud...

    I left only one form for better understanding...
    I want the combo to select all the information of a choosen user...

    Atha
    Attached Files Attached Files
    Atha
    20175337

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •