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