OnClick I would like to go add record then go to First text box

[elevins]

I have a form with 5 data entry text boxes and a add record button.
After I click the 'Add Record' command button I would like it to add the record then go to the first text box. This will make it easier for the people doing data entry. Any sugestions?

 

[Pampers]

Maybe:
Me.Textbox.Setfocus

Pampers
Keeping it simple can be complicated

 

[missinglinq]

Were you just asking for the way to go to the first text box (Pamper's post will do that) or were you askig how to add a record AND go to the first box? This will do both:

Private Sub YourAddButtonName_Click()
     DoCmd.GoToRecord , , acNewRec
     Me.FirstTextBoxName.SetFocus
End Sub

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[elevins]

Thanks Pampers that worked Great.