set focus ?

lipin

Registered User.
Local time
Today, 21:20
Joined
May 21, 2002
Messages
149
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.
 
After

DoCmd.GoToRecord , , acNewRec

Place

Me!ControlName.SetFocus

David
 

Users who are viewing this thread

Back
Top Bottom