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