Hi
I am working on a DB which has various tables linked to sharepoint. The DB has queries using data in these tables, which queries I then use to provide data for list boxes in different forms.
DB is used by various users, so it can be the case that the data in sharepoint changes, and a user would need to update the contents of the list box in the form being used. So far user would need to exit the form and wait for the updated data to be reflected in the query used by the particular form, or else use the refresh all button in the ribbon.
I would like to add a button in each form which refreshed the linked table, reruns the query and reloads the form so that the list box content gets updated. I have tried various options but none seem to work fully.
To refresh the linked table I am using the following:
dbs.TableDefs("Linked Table Name").RefreshLink
To rerun the query (a select query) I have tried various options but none seem to work properly.
How should I be doing this, pls?
I am working on a DB which has various tables linked to sharepoint. The DB has queries using data in these tables, which queries I then use to provide data for list boxes in different forms.
DB is used by various users, so it can be the case that the data in sharepoint changes, and a user would need to update the contents of the list box in the form being used. So far user would need to exit the form and wait for the updated data to be reflected in the query used by the particular form, or else use the refresh all button in the ribbon.
I would like to add a button in each form which refreshed the linked table, reruns the query and reloads the form so that the list box content gets updated. I have tried various options but none seem to work fully.
To refresh the linked table I am using the following:
dbs.TableDefs("Linked Table Name").RefreshLink
To rerun the query (a select query) I have tried various options but none seem to work properly.
How should I be doing this, pls?