Refresh report

[ilanray]

Hi,
When the report is open i created an event when click on one of the field. It open the form.
After i update the field (on the form) i would like to refresh the report.
I don't want to close the report and reopen
Any ideas?

Thanks

 

[arnelgp]

I don't want to close the report and reopen

you need to.

 

[Pat Hartman]

Seems like an awkward solution. Why are you starting with a report rather than just using a form for everything?

 

[sonic8]

After i update the field (on the form) i would like to refresh the report.

Look at the Report.Requery method.
Data in the database will only be updated when you save the whole record in the form, not individual controls (fields). So, you could execute the following line in the Form_AfterUpdate event procedure.

Reports("YourReportName").Requery

@arnelgp , if it is possible to click a button on a report, it must be in ReportView, which allows using Requery instead of reopening the report.