Results 1 to 2 of 2
  1. #1
    Mark344 is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    1

    Conditions / Expressions

    Hi

    I have built a form with several fields from different tables (related) that does what I want it to. I now want to make an adjustment to fine tune the form. Ok, here’s the bit I’m confused about! On the form are two fields Campaign and Event. These two fields are combo boxes that simply allow a user to select which Campaign and Event respectively. The Campaigns and Events tables are related. What I want to do is have a user select a Campaign then only the Events (that are related to the selected Campaign) be offered for selection. What is the condition/expression I should use?

    Campaign Table...
    ID


    Name
    Desc

    Events Table...
    ID
    Name
    Desc
    Related Campaign (related to Campaign.ID)

  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
    That is called Cascading ComboBoxes or Cascading Lists. Try searching on those terms and you will find a ton of stuff.

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

Similar Threads

  1. (simple) Expressions give error message
    By P.Hofman in forum Forms
    Replies: 3
    Last Post: 01-21-2010, 01:57 AM
  2. Unsafe expressions are not blocked.
    By darksniperx in forum Access
    Replies: 8
    Last Post: 01-07-2010, 03:25 PM
  3. Query on multipl conditions.
    By Goldenbird in forum Queries
    Replies: 0
    Last Post: 06-28-2009, 11:45 PM
  4. Expression with multiple conditions
    By techexpressinc in forum Queries
    Replies: 3
    Last Post: 06-19-2009, 08:33 PM
  5. Iff Statement Meeting 2 Conditions
    By newbie in forum Access
    Replies: 11
    Last Post: 06-11-2009, 11:59 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