sql select problem
got a little problem here. can somebody tell me what's wrong with this one? i want to search a customer id in my table (like "L00003") but when i execute this, i get the error: "The Microsoft Jet Database engine could not find the object 'SELECT * FROM REKKL#BK6 WHERE Rknr = 'L00003''. Make sure the object exists and that you spell its name and the path name correctly."
sql = "SELECT * FROM REKKL#BK6 WHERE Rknr = '" & strSearch & "'"
Data1.RecordSource = sql
'gives error here:
I Only Walk In The Dirt, But My Steps Are Guided, And No Matter How Dark My Path Gets, I Light It...
Last edited by RuffRyder; 05-12-2004 at 03:28 AM.