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

    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
    Ottawa, Ontario, Canada; West Palm Beach FL
    What you are looking for is called Cascading Combo boxes.
    There is a free video tutorial here
    and more info here
    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