Results 1 to 3 of 3
  1. #1
    timandlindsay is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    1

    Cascading Combo Boxes in a TABLE (not a form)


    I am trying to populate a "Contacts" field combo box based on the information given in a "Company" field in a TABLE. I have found a number of people solving this issue using a FORM, but I am specifically look to do it in a TABLE.

    I have read a number of sites that recommend NOT doing so in a TABLE - but no explanation of why not. I use the table to input new data and modify old data - and maybe I shouldn't be, but that's all I know of Access so far (I'm a newbie).

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Using combos in a form is absolutely fine - both individual combos & cascading combos

    Table level lookup fields (AKA combos at table level) are definitely NOT recommended
    Here are two links that explain the main reasons for not using them:
    The Access Web - The Evils of Lookup Fields in Tables (mvps.org)
    Table Lookup Fields - Mendip Data Systems

    I don't understand how it would even be possible to have cascading combos in a table.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    There is no good reason to use lookups in tables, after all, tables are for storing data, queries are mainly for retrieving data, forms are for entering/editing data and reports are for displaying data.
    The following link is one that is often offered as help with why Lookups should NOT be used in tables but rather in forms.

    http://access.mvps.org/access/lookupfields.htm
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Cascading Combo Boxes Not Syncing With Data In Table
    By VSCurtis in forum Programming
    Replies: 14
    Last Post: 05-06-2017, 12:24 PM
  2. Replies: 7
    Last Post: 12-09-2014, 12:24 PM
  3. Cascading combo boxes in datasheet form
    By gemadan96 in forum Forms
    Replies: 1
    Last Post: 06-20-2014, 09:59 AM
  4. Search Form - Cascading Combo Boxes
    By WeeTerrier in forum Forms
    Replies: 7
    Last Post: 12-05-2011, 08:26 PM
  5. Replies: 11
    Last Post: 08-29-2011, 01:45 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