Finding a record

[Guest]

Using VBA, I want to loop through an access table to see if it contains a
certain record but I'm having problems. Can anyone help with this?

 

[John Nurick]

Hi Josh,

Instead of looping through a recordset, it's usually much simpler to use the
DCount() or DLookup() function.