search entry to print using crystal report 8.5

can anyone please help me on this. **************************code**************************************** With frmreport.CrystalReport2 .ReportFileName = App.Path & "\report\rptsalesreport.rpt" .Connect = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=project;Initial Catalog=project" .SQLQuery = "select * from pharmasaleshistory where Medicine_Name = " & Me.txtmedname.Text .Destination = crptToWindow .Action = 1 End With ***********************end code*************************************** .SQLQuery worked if i search only medicine_id, but if i search medicine_name like what i have on my code it always show the error ***error detected by database dll***** any help will be appreciated...tnx