Using ADO in Excel VBA-Search for Field in Access Database

I'm fairly new to ADO and I'm trying to figure out how to search for a field inside an Access Database by using Excel VBA. I am able to retrieve a record by finding a value in a particular field, but when the field is not found is when I'm having the issue.

I would like to have an if statement or other workaround where if the field value I am looking for is not found, then a userform will popup to prompt the user to register their information. if I can just get the syntax down on how to do something else when the field is not found, I will be okay.


Below is the vba code I am using in Excel...

I am retrieving the user's Windows Logon ID, and then going to Access to Retrieve their email address from a table named Employees.

Please Login or Register  to view this content.

Hi

Here's one way.

Please Login or Register  to view this content.

HTH

rylo