Hey guys, I'm starting to get into VBA more heavily and I'm learning on my own from code written from the previous people here -- anyways I have a question.

Essentially I'm writing a module that will go row by row on on a table to find any matches to the current row's values. Then update a 'match' field move on to another row's values to repeat the matching process until we're finished with the table. So far I've put this together :

RESOLVED!

When populating a recordset, if the query that generated that recordset was empty I would get an error. That was because I was trying to perform a movelast to populate a recordcount. If I check for EOF before movelast everything works fine.

Sorry guys!