Add new records to table

[JamesN]

Hi,

I have a VBA code which submits details from a front end form into a back end sharepoint list. The code is quite large so I've had to split it into different modules and call them.

I need each of the modules to update the same line in the table. The first module uses rec.addnew. To add the details to the same line in the table in the next module, would this be a rec.update? I need the code written so it adds the details to the same line as the previous module.

Thanks

James

 

[Ranman256]

Normally, you don't need any code.
Access lets you add records via a form without code.

 

[JamesN]

Would rec.edit or rec.update work?