Is ProductID a number (Long Integer) in CustomerInterestT?

Keep going in the video because at first, it did not work for Richard either. Then he fixed it.

Kevin It is a number

Sandra Thank you, Sandra, and I will look for that too. I saw he fixed one by adding the CLNG, but this warning came before his fix on that. So he must have found this after that.

Since it highlighted "Set db = CurrentDb", double check your Dim statement just to make sure Intellisense didn't pop something in other than "database" while you were typing. I've been getting some crazy things popping in there when I just let the VBEditor finish the word for me. Sometimes it will just put "DAO", sometimes "database" or "databases" or "DBEngine".

Type mismatch is telling you that you're comparing two different kinds of variables, or at least Access thinks you are. Or that you have declared one type but you're trying to set it to another.

Thanks Donald for replying. I did look above at the DIM like you said and instead of Database it was Datebase. Funny that it never spotted that before this. That's one more thing I need to watch for. The other thing I've learned to watch is that it wants to type in re instead of rs. Is there a way to shut off that Intellisense thing in Access? Just curious. Ken