Well, I feel pretty dumb right now. That fixed the issue! Thanks.

I am trying to check for duplicate address records in a table before running an append query to add the user-entered address on a form. I am defining a string to capture the street number, name, suffix and city and then using DLookup to search the table (tblLocation). The problem is that the code keeps returning a data type mismatch in criteria expression error. I know it has to do with the street number field because the code works fine when it...