Combo box problem

[bigbadbess24]

I have a text box followed by three drop down boxes (Combo boxes). After I Inpute 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]));

When I go to the first drop down I get the date I want. But when I go to the remaining two boxes its gives me the date also. I want to go the the Guest Team and get the names and the same for the Home Team, but I keep the getting the date. How do I do this

 

[Oldsoftboss]

This is one way. Something to mull over.

Dave

 

[bigbadbess24]

I figure it out. I need to add 0";1":0" and 0";0";1" to the column widths. Thanks for your help