Reinitializing a Data Report

[Al Mason]

I have been working with VB 6.0 and trying to get a Data Report to change as I select a new record and reselect the show command button. The data report stays stuck on the original record. How do I get the report to recognize the new record and show it? It appears to need some sort of command to unload the previous report form and load the new form.
Also, is Crystal Reports better than Data Reports and if so, which version, who sells them, etc.?
Any help would be appreciated.
Thanks,
Al

[Dr_Michael]

If deDataEnvironment.rsReturningRecordset.State = adStateOpen then
deDataEnvironment.rsReturningRecordset.Requery
End If




Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece