here is the code for connecting Microsoft access database to vb6 and an error is occured in the line Set reccnc = dbTata.OpenRecordset( "Select * from cnc where WONO like '" &a.Text&"' and ItemName like '"&b.Text"'")
in this dbTata is the name given to acess database and cnc is the table in it and WONO and ItemName's are primary keys and through this code im trying to retrieve data that matches with both the textboxes. hope u can understand my problem. waiting for ur reply. neways thank u in advance.

apply proper spacing between words

"Select * from cnc where WONO like '" & a.Text &"' and ItemName like '"& b.Text & "'"



urt

Help yourself by helping someone.

Urt is right about the spacing. Also, if you're going to use the LIKE function, then your strings need wildcards. Try something like:

Set reccnc = dbTata.OpenRecordset("SELECT DISTINCT * FROM cnc WHERE wono LIKE '*" & a.Text & "*' AND ItemName LIKE '*" & b.Text & "*'")


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division