Report displays empty after updating a recordset

[143Aroul]

Hi,

strSQL = " SELECT * FROM Emoloyee"
rsMaster.Open strSQL, conn, adOpenDynamic,adLockOptimistic,adcmdText
rsMaster.fields("Name&quot = "Aroul"
rsMaster.Update

crystalreport1.connect = conn
'other statements
crystalreport1.printreport

When i call like the above the report is showing empty,
but if i introduce a message box in between rsmaster.update
and the crystalreport1.connect like below, the report is printing


rsmaster.update
msgbox "OK"
crystalreport1.connect = conn
'other statements
crystalreport1.printreport

 

[Som76]

Hi
I have also came across this problem.
If immediately we print the report after update, the report is not refreshed. But if a small delay introduced, then it works fine.
Try out by introducing a delay of 0.5 sec to 1 sec.
If u find a better solution please let me know as well.

Regards
Som

 

[CCLINT]

Are you using ADO or DAO?