I need to use crystal report to generate the distribution report
but when I try this code :


Private Sub cmdDistIssuePaper_Click()

crtDistribute.DataFiles(0) = App.Path & "\aungkee.mdb"
crtDistribute.ReportFileName = App.Path & "\Distribute_Report.rpt
crtDistribute.Destination = crptToWindow
crtDistribute.SelectionFormula = "{tblDistribute.DistributeID}= '" & txtDistributeID.Text & "'"
crtDistribute.Action = 1

End Sub

it doesn't work and the error statement show that

"ERROR in file C:\Test_Aungkee\Distribute_Report.rpt:
"ERROR in formular <Record Selection>.
'{tblDistribute.DistributeID)' ='7"
A number is required here.

** My report file name is Distribute_Report (Created by Crystal Report Version 8.5 and located in folder Test_Aungkee.

Did I miss something? require to do this code ?
or dis I make some mistake in SelectionFormular ?

If anybody know about this please let me know, this code is urgetnly require !! help me

Linn