Quote Originally Posted by xld
How does that help, it just skips the error, so it just avoids the problem?
I can see your logic.
The error occurs as soon as you start to type into the field so by adding the resume next it doesn't error and does the lookup correctly when the field is completed. I agree it's not a very good way to solve the problem but as a quick solution it'll do for now.