I have an Excel sheet that through a form, accesses an Access database. It also has a command button that updates records with data from the sheet. In my VBA code I'm am trying to do a 'rs.edit' but the intellisense doesn't have it listed and I get a 'Method or datamember not found' error when I run the command anyway. I have checked my references and am pretty sure I have all that I need. All my other database functions (like rs.addnew) work fine. Does VBA not support editing records from a database? Or am I forgetting something?
Reply With Quote