VBA code to update record in Access 2003 using Userform in Excel
I'm working on a project fro work where agents fill in a userform to save data in access. This work, but what I need is a way of retrieving a single record that populates a different userform that can be amended & the over-write the original record. I'm not sure if this is possible but some help would be great.
Attached is what I have so far & really need help getting the Update records part working
|