Forum Discussion
Solved
Open Report (strip out letters for Where clause)
Hello Experts, I have the following OpenReport code: DoCmd.OpenReport "rptPC", acViewReport, , "[DDNo]= " & Me.txtDrawNo I need to modify it since [DDNo] is not a number...it's text. There is...
Try this and let us know if it is successful or not.DoCmd.OpenReport "rptPC", acViewReport, , "[DDNo]= """ & Replace(Me.txtDrawNo, "DD","") & """"
Hi,
DoCmd.OpenReport "rptPC", acViewReport, , "DDNo='DD" & Me!txtDrawNo & "'"
Servus
Karl
************
Access News
Access DevCon
Hi Karl, this works too....