Using Access 2007
- based on table
- opens from button on form
- opens by DoCmd.OpenReport
- criteria parameter for DoCmd.OpenReport supplied by form controls
- opens in print preview
When selecting different criteria on form and opening report again after already opened, the report detail does not update accordingly.
Is the recommended solution to close the report if it is already opened and then reopen it?
Is it recommended that to avoid this issue, to open the report in report view as the criteria parameter in DoCmd.OpenReport will be applied every time the button is clicked to open the report?
Any help would be great! Thanks!