Results 1 to 5 of 5
  1. #1
    eugzl is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    68

    problem to create source for combo box


    Hi All.
    I created part of my Inventory database that give ability add devices to the system. Now I added new tblRequest table that will be source for fRequest form. That form will using to save a new device requests. In the relationship I linked tblDevices table to tblRequests table. But I cannot figure out how create source of data for cboDevice combo box in new fRequest form. I would like before select according device first of all to filter data by Brand then by DeviceType and finally select device with according device type, brand and model and then save a correct DeviceID value to tblRequest table. I will appreciate if someone will show how it to do. The attachment contains database file.

    Thanks.
    AddNewCascadeCB.zip

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    eugzl is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    68
    Hi orange. Thanks for reply.
    I know for filtering need create cascade combo boxes. I created it in fDevice form. My question was how create source of data for cboDevice combo box in new fRequest form that I have ability to save a correct DeviceID value to tblRequest table.

    Thanks

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You do it exactly the same like in your other form; you need to add your three unbound cascading combos (for brand, type and model) then you requery the DeviceID in its enter or got focus event to take into account your previous selections.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    CarlettoFed is online now Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    You can see the attached example.
    CascadeCbo.zip

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

Similar Threads

  1. Replies: 4
    Last Post: 04-26-2020, 02:33 AM
  2. Replies: 19
    Last Post: 06-26-2018, 07:13 AM
  3. Combo Box Row source problem
    By nbdwt73 in forum Access
    Replies: 2
    Last Post: 02-09-2014, 07:41 PM
  4. Replies: 1
    Last Post: 11-28-2013, 10:03 PM
  5. Replies: 3
    Last Post: 12-11-2012, 09:12 AM

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