Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    80

    Unanswered: Clicking on value in combo box and going straight to that record

    Hello all,

    I've set up a combo box, with a list of Name values from another table (I used the wizard to do this). Now I need to figure out how to either:

    a) Have the user click on their chosen name in the list and then the corresponding record will immediately appear;

    or

    b) Have the user click on their chosen name, then click on a button that will, when clicked, make the corresponding record appear.

    Any suggestions? I realise that it would require coding, and most likely in an OnClick control, but I just don't know quite how to do it myself. Any help or alternative suggestions are much appreciated.

    - Grace

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

    Talking

    Hi graceadair

    Check below, I rigged up a sample db for you to check out with just what you asked about. Mind you I did it fast but it should help. Look behind the scenes and check it out. Later tonight I will write the step by step process of how I did it if you still need help. It opens up to the form to use right away and is based on 2 tables. Didn't use the query this time, but did use the query on the other form in the program. Well, time to get outta here and hope this helps you out. Also, check your earlier posts as I try to give you short helper examples of what you are trying to accomplish, rather than just tell you. Also, try posting samples here to get your particular situation resolved much sooner. Someone on here will surely be able to help.

    bye for now...
    Bud
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    You may also want to try adding a combo box with the wizard enabled. One of the wizard options is "Find a record on my form that matches the control" which will accomplish what you want.

Posting Permissions

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