G
Gitche Gumee
I am linking to a SharePoint list from an Access database. The SharePoint
list updates a Project Information table. A query on the Project Information
table and several other tables is the record source for a Project Information
form.
When the Project Information form is opened, an update query runs to load
the Project Information table with the most recent data from the SPN. This
works fine.
What I would like to be able to do is periodically refresh the Project
Information table with the SPN data while the Project Information form is
still open. A Refresh button runs update queries to collect the data from the
SPN. A requery of the form then shows the most current data from the SPN.
The problem is that the update queries and form requery do not work UNLESS I
open the linked table in the background. That is, before I click the refresh
button, I have to manually open the SPN table. Then clicking the refresh
button causes the most recent data from the SPN to be displayed on the form.
Why is that? And what can I do to get around it?
list updates a Project Information table. A query on the Project Information
table and several other tables is the record source for a Project Information
form.
When the Project Information form is opened, an update query runs to load
the Project Information table with the most recent data from the SPN. This
works fine.
What I would like to be able to do is periodically refresh the Project
Information table with the SPN data while the Project Information form is
still open. A Refresh button runs update queries to collect the data from the
SPN. A requery of the form then shows the most current data from the SPN.
The problem is that the update queries and form requery do not work UNLESS I
open the linked table in the background. That is, before I click the refresh
button, I have to manually open the SPN table. Then clicking the refresh
button causes the most recent data from the SPN to be displayed on the form.
Why is that? And what can I do to get around it?