Results 1 to 2 of 2
  1. #1
    hinchi1 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    181

    Cascading comboboxes

    I have a series of cascading comboboxes which work as expected. The second to last combo shows data for the rooms on a particular floor. The last box then shows what desk numbers have been added to that room. How could i change this last box to only show desks that have not been assigned to personnel? The filter i have behind the cboDeskNumber is:



    [forms]![frmPersonAdd]![cboRooms]

  2. #2
    Join Date
    Apr 2017
    Posts
    1,673
    When you use the combo box to attach desks to room, and at same time you filter out connected desks in RowSource query, then at same moment when you add a desk to room the combo remains empty, as the filter doesn't allow to show the combo as connected.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Cascading Comboboxes
    By JennyL in forum Access
    Replies: 3
    Last Post: 03-13-2017, 11:26 AM
  2. Trouble with Cascading ComboBoxes
    By shane201980 in forum Programming
    Replies: 3
    Last Post: 10-03-2012, 09:05 AM
  3. Cascading ComboBoxes
    By GAccess in forum Forms
    Replies: 1
    Last Post: 03-06-2012, 05:02 AM
  4. Symmetric Cascading Comboboxes
    By schwabe in forum Forms
    Replies: 15
    Last Post: 02-02-2012, 11:38 AM
  5. Cascading Comboboxes and Sub Forms
    By PaulCW in forum Forms
    Replies: 6
    Last Post: 10-07-2011, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums