Hiya,

I have the following problem in VB
I have a report which prints all my records.
Now I try to print only the record on my current form.
At the moment I use the followin code :

        rptbol1.SelectionFormula = "{tblBol.Bolnumber} = 18"
        rptbol1.Action = 1

18 is here a number of an existing Bolnumber
So this works as long as I put the recordnumber to be printed in the code
Now I'd like to have a method like this:

        Dim bolnr as Integer
        bolnr = Me.Bolnumber
        rptbol1.SelectionFormula = "{tblBol.Bolnumber} = bolnr"
        rptbol1.Action = 1

 => So bolnr is a variable

Does anyone know how I could define this ?

Thanx in advance,

Koen

rptbol1.SelectionFormula = "{tblBol.Bolnumber} = " & bolnr

On 7 May 1998 17:18:20 GMT, "Koen Van Tolhuyzen"