New Record in Access with VBA

[AndrewKent]

Hi there,

I am currently building a program in Excel whereby I can send data to and from an Access Database. I have copied in a segment of code that I use to update one table in the database...

Set DBRecordSet = New ADODB.Recordset
    DBRecordSet.CursorLocation = adUseServer
    DBRecordSet.Open Source:="StaffData", ActiveConnection:=DBConnection, CursorType:=adOpenDynamic, LockType:=adLockOptimistic, Options:=adCmdTable

...however I want to modify this so it updates not just "StaffData" but "CustomerData" as well. How would I do this?

Andy

[Jan Karel Pieterse]

By creating a separate recordset that handles the customerdata. I assume you have some index field you can use to determine which records need to be changed.