Results 1 to 3 of 3
  1. #1
    desmonda is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    6

    Angry Desperate help: Query in table

    I type in a sport and the next combo box updates through query to show teams from that sport.



    SELECT SportTeams.Team FROM SportTeams, Results WHERE (((Results.Sport)=[sportteams].[sport] And (Results.Sport)=[Previously typed text);

    When I use a parameter and type the sport in again it works, however this is redundant so I was wondering if this would work.

    Any help would be appreciated

  2. #2
    desmonda is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    6
    would a subquery work?

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Are you looking for Cascading Dependent Comboboxes?

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

Similar Threads

  1. desperate for homework help in access
    By catzjenn in forum Access
    Replies: 8
    Last Post: 04-23-2013, 11:51 AM
  2. In desperate need of help with my project
    By Jasmine0305 in forum Access
    Replies: 5
    Last Post: 02-11-2012, 05:06 PM
  3. Desperate Dan
    By Andyjones in forum Access
    Replies: 0
    Last Post: 01-27-2012, 07:09 PM
  4. Desperate Need of Help - Queries
    By Niki in forum Access
    Replies: 2
    Last Post: 07-25-2011, 10:36 AM
  5. Matching Rows in Table (kinda desperate)!
    By UCBFireCenter in forum Queries
    Replies: 0
    Last Post: 10-15-2009, 04:21 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