How do I know if a record exists with sertain criteria

  • Thread starter Thread starter Nic
  • Start date Start date
N

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
 
Back
Top