Results 1 to 4 of 4
  1. #1
    racefan91 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Sep 2013
    Posts
    43

    List Box Based on Criteria in Same Row

    Wondering if somebody can point me in the right direction for this as it doesn't seem like it should be too difficult. I have a table where the columns are team1, team2 and winner. Team1 and team2 are comboboxes that show all the teams in Team table. After I pick the team1 and team2 in a row I want to make a listbox that shows only those two teams as options for the winner. Any help is appreciated.

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    You can make a query from your all teams table to look up the team1 and team2.

  3. #3
    racefan91 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Sep 2013
    Posts
    43
    For the winner rowsource query?

  4. #4
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Yes.

    Create a query use "ALL TEAMS" table and use it to find the team1 and team2. Something like this,

    SELECT [ALL TEAMS].NAMES
    FROM [ALL TEAMS]
    WHERE [ALL TEAMS].NAMES IN ( [TEAM1], [TEAM2] )

    Note: You will need quotes for TEAM1 and TEAM2 since they are TEXT field.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-08-2014, 01:02 PM
  2. Replies: 5
    Last Post: 08-02-2012, 09:44 AM
  3. List Criteria
    By drow in forum Forms
    Replies: 1
    Last Post: 03-12-2012, 11:19 PM
  4. List populating based on criteria
    By Stedman in forum Forms
    Replies: 3
    Last Post: 08-06-2011, 12:46 PM
  5. list box with multiple criteria
    By white_flag in forum Access
    Replies: 6
    Last Post: 07-25-2011, 11:25 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