I have two tables linked with sharepoint lists. And I have a form in access db, each time when the form loads the table which is linked to sharepoint list should refresh automatically.
Is there ant way to do this in vba code?
I'm using
Application.DoCmd.TransferSharePointList acLinkSharePointList