i have an access form/switchboard that opens a report. the
switchboard buttons open the same report but changes the
query that the report is based on so the results are a bit
different depending on which button was pushed.
if the form is already open and i hit another button, it
doesn't refresh the report using the new query. i guess it
sees it's already open so it doesn't continue.
vba code to open report is:
[login to view URL] "rptProject", acPreview
is there a way to have a report refresh/update itself if
it's already open?
22 freelancers are bidding on average $29 for this job
Hi, I read your description and the simplest way to do so is by closing the report if it is open and reopening it. Relevant Skills and Experience vba Proposed Milestones $30 USD - default