I have an Access 2007 db linked to sharepoint tables. I need to add a new record to the SharePoint table using an Access form. The form is created from the table. I open the form in add record mode and the user inputs all data. All inputs work fine except two multiselect combo boxs.
I am using the .addnew agruement in the beginning then setting each field in the recordset equal to the values in my controls with a .update at the end of my procedure. The record is not saving. I get an error of data mismatch. The combo boxes are bound to an ID column.
Also if I try to save without these two controls, i get a "table schema has changed" error.
I am sure there is an easy solution but this SharePoint table is 26K records and slow so my patience is dwindling.
Thank you in advance.