Results 1 to 2 of 2
  1. #1
    nellolopez is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    1

    Conditional Formula?


    Help...I am developing a simple single database. I have two to three fiels that I want to relate (maybe not?). Here it is... field1 is a drop down list of departments and field2 is a drop down list of equipment. What I would like to be able to do is to select a department from field1 and have field2 provide (auto) a list of equipment that are only available for the department I selected on field1.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,061
    What you are looking for is called Cascading Combo boxes.
    There is a free video tutorial here
    http://www.datapigtechnologies.com/f...combobox2.html
    and more info here http://www.baldyweb.com/CascadingCombo.htm
    Good luck.

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

Similar Threads

  1. Formula mod help
    By jcaptchaos2 in forum Access
    Replies: 2
    Last Post: 04-25-2011, 02:55 PM
  2. SQL Formula to Sum Itself
    By Scorpio11 in forum Access
    Replies: 1
    Last Post: 02-19-2011, 11:22 AM
  3. Formula in Form
    By jlclark4 in forum Forms
    Replies: 1
    Last Post: 02-03-2011, 04:41 AM
  4. Formula for form
    By chanoc24 in forum Forms
    Replies: 3
    Last Post: 08-18-2010, 10:40 PM
  5. Formula
    By hschrunk in forum Access
    Replies: 3
    Last Post: 05-18-2010, 01:40 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