Automatically update Sharepoint related tables in Access 2010?

Question

I have two tables related to sharepoint lists. And I have a db access form, every time the form loads the table associated with the sharepoint list, it should be updated automatically.

Is there any ant way to do this in vba code?
I use

 Application.DoCmd.TransferSharePointList acLinkSharePointList

Answer 1

Use CurrentDb.TableDefs("TableName").RefreshLink(replace TableNamewith your actual table name).