[RESOLVED] run-time error in query

[puzzleofurheart_23]

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






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

[danasegarane]

Try this one

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

[puzzleofurheart_23]

thanks..hehehe