Another From Problem

[bigbadbess24]

Another question

I have a text box followed by three drop down boxes (Combo boxes). After I Input a number into the text box I have a query that runs to give me information on that number.
SELECT [tbl Matches].Date, [tbl Matches].[Guest Team], [tbl Matches].[Home Team]
FROM [tbl Matches]
WHERE ((([tbl Matches].Match)=[Forms]![frm Match Results Reporting]![Match Number]));

After there is information in the Home team I have another set of Combo boxes (name home players, home partners, away players and away partners) to give me my list of players. My query for the home players is:
SELECT DISTINCT [tbl Players-School].[Players Full Name]
FROM [tbl Players-School]
WHERE ((([tbl Players-School].School)=[Forms]![frm Match Results Reporting]![Home Team]));
Now after I get my information in for the school, I go to players and drop down is blank.
I have tried to do the Home Team as stand alone drop down (getting its information from a table instead of my query) it works. So I do not know if there is something wrong with the query in the beginning or is my last query wrong?

 

[Dreamweaver]

[tbl Matches].Date

Date Is A Reserved word in access that could be doing it try [tbl Matches].[Date] but would be a lot better to use a different field name.

Also after selecting a value in one combo box requery the others so they get there data.
mick

 

[bigbadbess24]

Thanks for catching the typo on Dates. But that does not solve my problem at all, I am still getting blanks in my Player Full Name pull down.