Results 1 to 6 of 6
  1. #1
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15

    Cascading combo boxes

    Hi all

    I have been trying to modify a sample database to suit what I want to do but I am getting stuck on the very first part cascading combo boxes i want to open a form and add multiple items to a table - first i want to select, from a combo box a department - then select a supplier from all the suppliers/maufacturers related to that department then select a stock item based on the description from all the items available from that supplier



    I have attached the database I am using to modify and my database

    I would creatly appriciate if someone could get me started and pointed in the right direction the original databased used table and I'm using query's so not sure if what I am trying to do will work - I have looked at so many examples I am getting my self confused (I don't expect someone to do it for me but would just really appricate some guidence)

    Cheers Guys

    Jackie

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

  3. #3
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15
    Hi there

    Thanks for the reply and for the tutorial links they are really good and helped simplified things after reading loads of different techniques and getting really confused. I have followed the tutorial but I'm having difficulty setting the second combo box to filter - it just either comes up blank or asks for what "Forms!EnterStock.Dept" which it should be getting form the Dept combo box - I must be missing something I have attached what I have done would be great if someone could have a look and let me know where I goin wrong I just keep going over the same thing over and over

    Cheers

    Jackie

  4. #4
    Jackie is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2011
    Posts
    15
    Hi All

    Ignore my last post- I was having a blonde moment again instead of entering
    Forms!EnterStock.Dept i put Form!EnterStock.Dept (left the S out of Forms!!!)
    Stupid

    So all working now

    Cheers all jackie

  5. #5
    CCourt is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2013
    Posts
    2
    Hi does anyone have any links for cascading combo boxes that have a 2nd drop down on these?

  6. #6
    CCourt is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2013
    Posts
    2
    Would an attachment help? I realise I'm new here but pllleeeeaaaaaseeee

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

Similar Threads

  1. Cascading combo boxes
    By combine21 in forum Forms
    Replies: 3
    Last Post: 12-02-2010, 12:57 PM
  2. cascading combo boxes on Continuous Forms
    By Jerry8989 in forum Forms
    Replies: 0
    Last Post: 10-12-2009, 10:02 AM
  3. Cascading Combo Boxes
    By desireemm1 in forum Programming
    Replies: 1
    Last Post: 10-05-2009, 06:00 AM
  4. Cascading Combo Boxes
    By gjw1012 in forum Access
    Replies: 1
    Last Post: 07-25-2009, 04:59 PM
  5. Problem with Cascading Combo Boxes
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-13-2008, 09:44 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