Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access (97) Beginning User (97)

    Just joined the lounge, and having looked over the threads, I think this should be a very easy one. I'm designing a form to drill down into query results. I have the results query how I want it- populating a list box, and I have the combo box, that will furnish the look-up value- at least I think so. I am unable to get a double click on the look-up combo box to run the query with the filtered results. I have the row-source on the list box "......WHERE [combobox].Value". I'm not sure where to go next. Is "requery" required in "DoubleClick" as the event? Is there something else that I am missing? Thanks for any help.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (97) Beginning User (97)

    Use the afterupdate event of the combobox and enter
    Me.ListboxName.Requery
    Francois

  3. #3
    Lounger
    Join Date
    May 2002
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (97) Beginning User (97)

    Beautiful !! It works!

Posting Permissions

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