Data type mismatch in criteria expression (1 Viewer)

DDivney · Jul 22, 2012

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

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?

John Big Booty · Jul 22, 2012

If the field TournamentID is a numeric field then you do not need the inverted commas, and you code should look like;

Code:

Me.Home.RowSource = "SELECT Team.TeamID, Team.TeamName, Team.TournamentID " & _
"FROM Team " & _
"WHERE Team.TournamentID = " & Me.TournamentID.Column(0) & _
"ORDER BY Team.TeamName; "

DDivney · Jul 22, 2012

That worked very well, thank you! I'm still learning on the fly, which is quite awful really... What do the inverted commas denote then?

John Big Booty · Jul 22, 2012

You require the inverted commas for String fields and a Date field must be enclosed between hash marks (#).

Data type mismatch in criteria expression (1 Viewer)

DDivney

Registered User.

John Big Booty

AWF VIP

DDivney

Registered User.

John Big Booty

AWF VIP

Similar threads

Users who are viewing this thread