Hi guys I keep getting an error :


Run-time error '3464':

Data type mismatch in criteria expression



the code that gets highlighted is the following



Set rs = db.OpenRecordset("SELECT * FROM `schedule` WHERE `theid` = " & "'" & Form9.ListView1.SelectedItem.SubItems(4) & "'")




any ideas?

Thanks