I want to display a report, but the first time the program runs, the report that is displayed is blank. That's because there is not a requery command. So, I wrote this code:

If dePrinting.rsPrintFields.State = adStateOpen then
dePrinting.rsPrintFields.Requery
End If



However, still blank on first run! That's because:

dePrinting.rsPrintFields.State = adStateClosed



But if I don't check this state, it fires because recordset is open! How else can I requery?

Michael Vlastos
Automation Engineer
Company Modus SA
Development Department