Results 1 to 2 of 2
  1. #1
    Batselot is offline Novice
    Windows 8 Access 2016
    Join Date
    Aug 2018
    Posts
    14

    Cascading combo boxes in tables


    Hello there,while I was doing my research I figured out this thing called cascading combo boxes which will be useful upon my research;but I figured out that can be only done on forms.Is there anyway I can do this in tables?For example;I want to choose a lesson code such as ENG 304 and I want the learning outcomes to come up only of ENG 304.Thanks a lot

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,987
    NO!

    Tables are for storing data.
    Although it is possible to have combo boxes in table fields, table level lookups are a bad idea which should be avoided.

    Users should never interact with tables directly. That's what forms are for.
    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

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

Similar Threads

  1. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  2. Cascading combo boxes... help me again please!
    By aqueousdan in forum Access
    Replies: 6
    Last Post: 09-20-2016, 06:54 AM
  3. Replies: 4
    Last Post: 10-09-2013, 03:44 PM
  4. Cascading Combo boxes
    By finsmith in forum Forms
    Replies: 10
    Last Post: 02-12-2013, 09:37 AM
  5. Replies: 3
    Last Post: 01-30-2012, 09:43 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