First of all, in Access VBA, when referencing the values in text boxes, lose the .text, then it will stop jabbering about not having the focus.
Just to be sure, are you programming in VB or VBA right now?