GregoryWest
Registered User.
- Local time
- Yesterday, 21:45
- Joined
- Apr 13, 2014
- Messages
- 161
I have some VBA code that opens a form gets some user information from the user (this is all working great) and returns to VBA.
Here is where I am having problems! I need to make sure VBA is looking at the most current data available, NOT the data when VBA started. On the query on the calling form references the critical table, but I am always getting the data as it was when the VBA started not the current data. How can I force access to reread the tables and not use cached data?
Greg
Here is where I am having problems! I need to make sure VBA is looking at the most current data available, NOT the data when VBA started. On the query on the calling form references the critical table, but I am always getting the data as it was when the VBA started not the current data. How can I force access to reread the tables and not use cached data?
Greg