Thanks for the help!! and the quick reply. I tried the changes you suggested but on the Lostfocus sub routine I get the error message: "procedure declaration does not match description of event or procedure." That was the same message I got every time I tried changing and passing the variable. Do you have any other suggestions I can try?