[RESOLVED] recordselecttion formula in CR8.5

[Rob3161]

i have prob in following... i am using VB6/CR8.5/Access Database.
Dim CrAppl As New CRAXDRT.Application
Dim CrRep As New CRAXDRT.Report
Set CrRep = CrAppl.OpenReport("D:\Visual Basic Proj/VatSoft\Wlist2.rpt")
With CrRep
'Selection
.RecordSelectionFormula = "{Wlist2.wlistno} = 2 "

End With
wlistno is integer field.
how do i pass this no using a integer variable??

Q.2 how can i refresh this report if data does not comeup on report??? at runtime using codes)

[brucevde]

Dim CrAppl As New CRAXDRT.Application
Dim CrRep As New CRAXDRT.Report
 
Dim x as Integer
 
Set CrRep = CrAppl.OpenReport("D:\Visual Basic Proj/VatSoft\Wlist2.rpt")
With CrRep
'Selection
X = 2
.RecordSelectionFormula = "{Wlist2.wlistno} = " & X

[Rob3161]

Yes That syntex is correct but still i have to press refresh button when i change Wlistno value, I dont understand why?? how can I give refresh command to CR before desplaying it?