How do I know if a record exists with sertain criteria

[Nic]

I'm trying to just test to see if a record exists within a recordset. I
thought perhaps that
rec.findfirst returned a Boolean value, but it doesn't..it just attempts to
find the first occurrence of your criteria.
I would just do a bunch of openrecordset's with a "WHERE" for each thing I'm
searching for and then test to see if it is .EOF, but wouldn't that put a
larger burden on my computer then just going through an already open
recordset?

Thanks!
-Nic

 

[Nic]

Nevermind...i found a .NoMatch method which is what I'm looking for