[RESOLVED] run-time error in query

hi.. i don't know how to fix this error..my code is:
Adodc4.RecordSource = "select * from replenishment_details where replenishment_no like ='" & replenishment_num & "' and policy_type = '" & ptype & "'"
Adodc4.Refresh

replenishment_num and ptype are string data type..everytime i run it, it has this error



http://pic20.picturetrail.com/VOL159.../229629769.jpg


can you help me modify my code? something is wrong ..

Try this one

VB Code:

Adodc4.RecordSource = "select * from replenishment_details where replenishment_no like  '" & replenishment_num & "' and policy_type = '" & ptype & "'"

thanks..hehehe :wave: :wave: :wave: :wave: :wave: :thumb: :thumb: :thumb: