Data Type mismatch in expression

[Prysson]

Here is my query


.Open "SELECT tblLocation.*, tblArea.* FROM tblArea INNER JOIN tblLocation ON tblArea.LocationID = tblLocation.LocationID WHERE tblLocation.LocationID =’” & Me!cmbLocation & “’ & tblArea.AreaName =’” & Me!txtArea & “’;"

I suspect that the problem is because the Me!cmbLocation is actually a Long Integer value....not sure how to fix the problem though.

 

[Jon K]

Assuming tblLocation.LocationID is numeric, try this:-

.Open "SELECT tblLocation.*, tblArea.* FROM tblArea INNER JOIN tblLocation ON tblArea.LocationID = tblLocation.LocationID WHERE tblLocation.LocationID =" & Me!cmbLocation & " and tblArea.AreaName ='" & Me!txtArea & "';"