I have a form to enter employee info. I enter the empl #, then the data, then click ADD RECORD button created by the wizard.
I would like for the focus to go back to the txtEmplNumber textbox so I can enter the next Number. I tried:
txtEmplNumber.SetFocus
in both the Exit event and the Lost Focus event of the ADD RECORD button. I get the error "You can't go to the specified record.
You may be at the end of a recordset."
I don't have a clue as to what that means.
I also tried to code it in the Click event of the ADD RECORD button, but with all the code the wizard put in there, I tried to setfocus and couldn't get it to go.
Can anyone help? THANKS.
I would like for the focus to go back to the txtEmplNumber textbox so I can enter the next Number. I tried:
txtEmplNumber.SetFocus
in both the Exit event and the Lost Focus event of the ADD RECORD button. I get the error "You can't go to the specified record.
You may be at the end of a recordset."
I don't have a clue as to what that means.
I also tried to code it in the Click event of the ADD RECORD button, but with all the code the wizard put in there, I tried to setfocus and couldn't get it to go.
Can anyone help? THANKS.