refreshing command in DataReport

[scro11bar]

Hi,
I'm displaying a report using DataReport in VB 6.0. I've designed the data report using DataReport Designer. I created a Connection in the DataEnvironment and set Commands in the DataDesigner to retrieve data from a sql server backend. Everything works fine. But if open up a report for July and then try to open up the report for August, I'd get the July values. I would have to close the program and reopen the data report for it to display the August values. So what I want to know is how to refresh the commands in the DataEnvironment. In the DataReport Designer I can right click on Command1 and select refresh. But I don't see any Refresh member function associated with the VB object DataEnvironment. Any suggestions?

Thanks in advance.
- G. Rush

 

[Scoty]

Yo G,

Private Sub DataReport_Terminate()
On Error GoTo ErrorTrap
Unload deQA 'This is the name of my data enviroment
Exit_ErrorTrap:
    Exit Sub

ErrorTrap:
    MsgBox "This error occurred in the DataReport_Terminate module in the " & Me.Name & " Report" & Chr(13) & "The error number is " & Err() & Chr(13) & "The error description is " & Err.Description & " Please exit back to the Menu and try again"
    Resume Exit_ErrorTrap
End Sub

hth
Scoty : "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),