Results 1 to 5 of 5
  1. #1
    DRSarchitects is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Western PA
    Posts
    3

    Want to limit options in a field 2, based on the selection in previous field 1

    We want to limit the options in a field "Sub-System" that the user will select from; based on the selection in the previous field "System".

    The current setup; user selects the "System" (Architectural, Mech, Elec, Plumb, etc.). Then they select the "Sub-System" that corresponds to the System (exterior walls, roofs, windows, etc.),
    either in "FCA_DATA" Table or Form.

    We want the Sub-System list to be shortened to only show those Sub-systems that are connected to the Systems. The current list contains 114 Sub-Systems.
    Architecture would only show 8 sub-systems, Mech only listing 12 sub-systems. We have a table [Systems], that lists all 15 Systems. We have another table [Sub-System] that lists the


    a. (systems, connected to previous table), b. Sub-systems, c. Useful Life of sub-syst, d. notes

    I am having a hard time trying to form the search question in Google to help me...

    Thanks!!!!!!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Cascading Dependent Combobox?

  3. #3
    DRSarchitects is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Western PA
    Posts
    3
    ?? I am sorry, I have not worked in Access in years. Trying to learn this along the way.

    Can I search Cascading Dependent Combobox" for more help?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    DRSarchitects is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Western PA
    Posts
    3
    Thank you. I will go through the video again and try it out in v2010.

    Thank you. I know know what its called. YAAA.


    Robert

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

Similar Threads

  1. Limit data entry based on another field
    By chemengr in forum Forms
    Replies: 5
    Last Post: 01-02-2014, 01:21 PM
  2. Replies: 7
    Last Post: 02-10-2012, 08:08 PM
  3. Replies: 10
    Last Post: 11-21-2011, 02:56 AM
  4. Make new field based on previous field's answer
    By VictoriaAlbert in forum Access
    Replies: 1
    Last Post: 04-11-2011, 09:54 PM
  5. Replies: 2
    Last Post: 05-05-2010, 02:52 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