Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015
    Posts
    20

    Unanswered: Filtering comboboxes based on input of other combobox

    I'm trying to filter one combo box based on the input of the other combobox. I've read a few articles and watched a couple videos.

    I have two combo boxes. Building and room. They come from different tables and data is pulled using separate queries.

    Seems it's as simple as putting "form! [Yourform]! [Firstcombobox]" or in my case, form! [Frmsubform]![buildingnamefk].

    When I open up the form it asks me to enter parameter value. It's almost like it doesn't see the first combo box. I wonder what the problem is. I'm thinking it might be my bound colomn. Your help is appreciated.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    put code in the con click event of the combo vox to populate the next combo box
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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