Forum Discussion
Maxine14062
Jan 11, 2024Brass Contributor
Pause code
I am running quite a few queries in VBA to create a master query that is the recordsource for a report before opening the report in preview mode. Is there a command that would create a short pause to...
- Jan 12, 2024Thank you so much.
Tom_van_Stiphout
Jan 12, 2024Iron Contributor
Do you mean to say you are Creating or Updating queries before running the report?
In that case you need to refresh the QueryDefs collection:
currentdb.QueryDefs.Refresh
In that case you need to refresh the QueryDefs collection:
currentdb.QueryDefs.Refresh
Maxine14062
Jan 12, 2024Brass Contributor
Thank you so much.