Using the .Find method, only testing for .eof should be sufficient. If .eof then the record isn't found, so:
[tt] If Not oRecordSet.EOF Then
'oRecordSet!ObjectID = oAECObjectID
oRecordSet![Style] = oStyleName
oRecordSet!Area = oArea
Else
oRecordSet.AddNew
oRecordSet!ObjectID = oAECObjectID
oRecordSet![Style] = oStyleName
oRecordSet!Area = oArea
End If
oRecordSet.update[/tt]
- should do the trick (added an .update at the end) - since you've "found" (hopefully) objectid, there shouldn't be any need to "edit" it. But I should have thought your solution should have worked... Try stepping thru the code (hit F9 on the first executable line, then F8 to run line by line). Style is a property in Access, hence the [brackets], but don't know if that's anything to do with it.
Roy-Vidar