Editing SharePoint table using MS Access VBA code.

[aabousetta]

Good day.

I have SharePoint table linked to MS Access. The table consists of number of records and each record has number of fields. I want VBA macro that can refresh the link and modify field A when field B contain string "New" and save the table.

Thank you for your generous help.