RecordSet Problem - Mismatch error

[UmaGrama]

I keep getting this error "Data type mismatch in criteria expression" (error number 3464) when I execute the following code:

Dim Rst As Recordset
Set Rst = MyDB.OpenRecordset("SELECT * FROM Hospede WHERE Hospede.Quarto=102&quot

What could be wrong???

 

[Maquis]

What data type is your Quarto field? If it's a text field then you need quotes around the 102.

"SELECT * FROM Hospede WHERE Hospede.Quarto='102'"


Maq
<insert witty signature here>