Problem1: Data Report is not refresh

[bisdave]

Data Report is not refresh until i reload the program

The following is my code. I have set DE(Data Environment) = Nothing and Invoice (Report Name) = Nothing

==============================================
Code:

szSql = "select contract, DueDate, Amount, Cname, Csur From contract, ar_sub, customer where contract.custid = customer.custid and contract.contractno = ar_sub.contractno and "
szSql = szSql & "ar_sub.subid like '" & SubID & "' and "
szSql = szSql & "month(duedate) like '" & m & "' and "
szSql = szSql & "year(duedate) like '" & Year(Date) & "' "

Invoice.Sections("section2").Controls("lblSub").Caption = Sname
DE.Commands("Invoice").CommandText = szSql
Invoice.Show
Set Invoice = Nothing
Set DE = Nothing

==============================================

[mxnmx]

This example might help, I use the following to create parameterized Data reports.

Load DENREPORT
    With DENREPORT 'Data Environment
    If .rsGroupStat.State <> 0 Then .rsGroupStat.Close 'rsGroupStat is Command Object
    .GroupStat Trim(strGroupID) 
    End With
    GroupStat.Refresh
    If GroupStat.Visible = False Then GroupStat.Show

I hope it helps...

[bisdave]

Thank you for your help

but it's still cannot refresh