Return to First Tab Field

[ESTAGroup]

I am using a form to enter new records into a table. When I press ENTER, it writes the data to the table but does not leave my cursor at the start of the tab order. How do I make it do this?

Thanks.

Gregg

 

[FancyPrairie]

In the AfterUpdate event of the form, enter:

YourFirstField.SetFocus

 

[ESTAGroup]

I tried that and it is telling me that the macro does not exist. I must be missing something.

 

[PaulF]

I'd add the code to the command button that saves the data... after saving it.. just add a the line to set the focus back to the first textbox (i.e. Textbox name is txt1...)

txt1.SetFocus


It sounds like you might be trying to add it as an action to occur by placing that code in the textbox next to the Event.. when you should be selecting [Event Procedure] in that textbox, and then place the code in the Form's module

Private Sub Form_AfterUpdate()
txt1.SetFocus
End Sub

PaulF

 

[TheAceMan1]

How are ya surferboy30 . . . . .

[blue]FancyPrairie[/blue] gave an excellent fix for your problem, however, it appears [blue]you may have put it in the wrong place[/blue], particularly in accordance with your return post.

So . . . in form design view, call up the properties for the form. [purple]Remove whats ever in the After Update event.[/purple] Make sure the cursor is on the event line and click the three elipses just to the right. You are now in the VBE editor an this is where the line given by [blue]FancyPrairie[/blue] goes. When you get finish,it should look like this:

[blue]Private Sub Form_AfterUpdate()
   Me![purple][b]YourFirstFieldName[/b][/purple].SetFocus
End Sub[/blue]

See Ya! . . . . . .