why are you doing this on the on change event? This means everytime a change in the field occures the application will open the recordset, check if the value is in there already and do something based on that. This obviously would slow things down a lot. You should put this code on the before update event of the control. This way the check will just happen ones when the "whole" value is typed in and can be evaluated against values in the recordset.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.