Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    3

    Unanswered: Filtering Combo box from another subform

    I have a main form(Client), on my main form I have several tabs. On one of my tabs is the client information and within that tab I have a subform that provides who is all in the household(this information is in datasheet view and typed in such as First & Last name). Then on one of the other tabs I have Life skills, which has a combo box. In this combo box I would like for it to filter the only the names that were entered into the first tab.

    So say on the datasheet names entered are

    Joe
    Sarah
    Jim

    On my Life Skills tab, I would like the dropdown to show only those names entered.

    I am able to have it show those names, however, only on the first instance of the form. If I open the form, look up an existing client, go to the life skills tab, it will filter. However, if I change the client it does not refresh. I put the criteria in the query and maybe I need to write code so that it will refresh. But I'm not sure. Any ideas/help appreciated!

    Thanks
    Kim P

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Combos do not refresh dynamically when the data source changes. You need to use:
    Code:
    Me.<Combo Name>.Requery
    Have a nice day!

  3. #3
    Join Date
    May 2012
    Posts
    3
    Swore I tried that. But apparently I didn't! Thank you very much!

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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