Wanna do a find on a recordset with 2 primary keys.

[qwert231]

Any ideas how do do a find on a recordset with 2 primary keys. There could be duplicates in either field, so I have to do a find using both fields as Criteria. Any ideas?

 

[durug]

Using the distinct keyword?

 

[Palooka]

Using the

rs.Filter

function?

 

[qwert231]

Hmmm... now I opened this recordset to do a batch update... I'll try it, but is there anything else I may need to be aware of.