🚀 go-pugleaf

I use VB5 and Crystal Reports 4.6, so this may be bollocks. But in these
versions selection formulas are written (using yours as an example):

PrtCurrent.SelectionFormula = "{woMain.WorkOrderID}""" & ID  & """"

Try this.


"Corey Harbaugh" <charbaugh1000@hotmail.com> wrote in message
news:Rb2R5.65$7.99512@typhoon.kc.rr.com...
> I have a simple DAO app.  I want to use the crystal report control for a
> custom report that I made for this app.  It's the client report.  When the
> client creates a new record I want them to be able to print just the
current
> record.
>
> I have a menu to print the report here is the code for the click event.
>
> Dim ID as Byte
> ID = txtWorkOrderID.Text        'this is the primary id for the table, its
> also displayed as locked textbox on the client form.
> PrtCurrent.DataSource = "ctsworkorder.mdb"        'this is the database,
> PrtCurrentRecord is the name of the Crystal Report Control
> PrtCurrent.SelectionFormula = "woMain.WorkOrderID" & ID "         'woMain
is
> the table, WorkOrderID is the primary id for the table
> PrtCurrent.PrintReport            ' print to screen
>
>
> I get nothing from this code, the control doesent even open!  What am i
> doing wrong?  I have the report name in the Crystal Report Contol
propertys.
>
>
> Help ME!
>
>
> Thanks,
>
> Corey
>
>