Hi all,
I'm trying to get a SQL quesry into a recordset but i keep getting an error message saying: type mismatch
here's what i've got......
can anyone help?
Thanks,
Spinkung
I'm trying to get a SQL quesry into a recordset but i keep getting an error message saying: type mismatch
here's what i've got......
Code:
Dim sql As String
Dim rs As Recordset
sql = "SELECT multiFlag " & _
"FROM Charges " & _
"WHERE code = '" & Me.comboCharge.Column(0) & "'"
Set rs = CurrentDb.OpenRecordset(sql)
can anyone help?
Thanks,
Spinkung