Thank you for looking at my question,
I am putting a form together in an Access 2013 database that will enable user(s) to open report(s) via button click.
The tables/queries behind the reports are linked tables from Excel spreadsheets.
I would like the button click to refresh the relevant linked table(s) before opening the report to ensure that the data in the report is current.
How do I do this please using VBA?