Results 1 to 4 of 4
  1. #1
    vandy is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    2

    Question Cascading Combo Boxes (multiple tables!) HELP

    Okay I need some help with cascading combo boxes. See below:





    Master Site Table: Site ID (Investigational Site), Investigational Site, Mailing Address, Mailing Address 2,
    Mailing Address 3,Mailing Address 4, Mailing Address 5, Mailing City, Mailing State, Mailing, Zip Code, Mailing Country, Shipping Address, Shipping Address 2, Shipping Address 3, Shipping Address 4, Shipping Address 5, Shipping City, Shipping State, Shipping Zip Code, Shipping Country




    Site Personnel Table: Personnel ID,Site ID, Personnel Name, Title,
    Phone,Fax, Pager, Email Address, Active




    Project Table: Project ID, Site ID (Investigational Site), Detail ID (Protocol # and Product),
    Budget, Study Start Date,Study Completion Date, Comments, Precision Site




    Phone Contact Report Table: Site ID (Investigational Site), Detail ID (Protocol # and Product), Personnel ID (Personnel Name, Principal Investigator and Phone),Employee ID (Employee Name), Date Contacted,RE, cc, Comments, Comments 2, Comments 3, Follow-Up




    I am trying to create the form for the phone contact table. I want to be able to use cascading combo boxes to help fill in the information listed in ( ).
    But I have no experience in VBA. Can someone please help me get this working???

  2. #2
    rommelgenlight is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    77
    what do you mean about cascading? or do you mean drop-down?

    if you mean drop-down for cascading, when you have already created your combo box, right click it to view its properties, then goto data tab, then goto row source then click on the right the button with "..." there you can create what table you use to get your values.

  3. #3
    vandy is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    2
    i know how to get values in a drop down - what i want to know is how to get combo box 2 to only show values that are related to combo box 1. for example:
    combo box 1 lists california and nevada
    combo box 2 should only list cities in the state chosen from combo box 1 and it should also clear itself out if the chosen value in combo box 1 is changed.

  4. #4
    trigirl67 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Posts
    3
    I would make a table with the states for one column and corresponding cities for second column

    then
    On the first combo box
    for rowsorce, do a query and bring in the state field for above table

    then afterupdate event:
    Private Sub nameof1stcombobox_AfterUpdate()
    Me.nameofyour2ndcombobox = Null
    Me.nameofyourcom2ndbobox.Requery
    End Sub


    The second combo box in the row source
    do a query that brings in the state and cities but put in criteria for cities use Forms![name of your form]![name of your2ndcombobox]

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

Similar Threads

  1. Problem with Cascading Combo Boxes
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-13-2008, 09:44 AM
  2. cascading combo form
    By tonysomerset in forum Forms
    Replies: 0
    Last Post: 08-27-2008, 02:10 AM
  3. Cascading Combo Box
    By nywi6100 in forum Forms
    Replies: 0
    Last Post: 10-23-2006, 01:45 PM
  4. combo boxes
    By labrams in forum Forms
    Replies: 0
    Last Post: 04-20-2006, 09:28 AM
  5. Combo Boxes
    By Mxcsquared in forum Forms
    Replies: 0
    Last Post: 01-19-2006, 04:59 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