I'm trying to make a cascading combo box, but the afterupdate event that updates the rowsource of the other combo box throws up this error. Basically, I have two fields, TournamentID and Home (as in home team). The rowsource for the TournamentID combo box is as follows
And its after update event is:
I've checked the data types and they're fine. Could this be some sort of referencing error?
Code:
SELECT [Tournament].[TournamentID], [Tournament].[TournamentName] FROM Tournament;
And its after update event is:
Code:
Me.Home.RowSource = "SELECT Team.TeamID, Team.TeamName, Team.TournamentID " & _
"FROM Team " & _
"WHERE Team.TournamentID = '" & Me.TournamentID.Column(0) & "' " & _
"ORDER BY Team.TeamName; "
I've checked the data types and they're fine. Could this be some sort of referencing error?