While that would be efficient, however the data is being populated via a form. To update a "search table" then run the query would include extra transactions: 6 queries/seeks to update the search table then another query to update the main table.
I decided on this:
'con = open connection
Con.Execute "UPDATE ...", , adExecuteNoRecords
I felt this would be more efficient than
'rs open with appropriate connection; seek and index support
rs.Index = "PrimaryKey"
rs.seek "pkval1", "pkval2", adSeekFirstEQ
rs!val1 = newval1
rs!val2 = newval2
I really can't find any documentation benchmarking the efficiency of ADO updates; it just doesn't seem to be out there.