Results 1 to 2 of 2
  1. #1
    Suzied is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2010
    Posts
    6

    Restrict Table values

    I have a Make_Model table which list make and models. Example:
    Make Model


    Honda Civic
    Honda Fit
    Nissan Maxima
    Nissan Tiida

    I have created a Cars table which used both fields in the make and model table as reference. So if the user when creating a new car select Honda, the value to choose from in the Model field is Civic and Fit and if they select Nissan values available would be Maxima and Tiida.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Search on Cascading ComboBoxes or Cascading Lists.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-04-2010, 05:26 PM
  2. Replies: 1
    Last Post: 03-13-2010, 12:32 PM
  3. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 PM
  4. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 AM
  5. Restrict form access to certain people
    By DannyBoy7783 in forum Forms
    Replies: 2
    Last Post: 06-09-2008, 06:18 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