When I update/add a record on a form and push the next record button the focus is still on the last field that I edited. Which event is triggered when the next record is selected so I can insert the vba code:
me![First Field].setfocus
When I update/add a record on a form and push the next record button the focus is still on the last field that I edited. Which event is triggered when the next record is selected so I can insert the vba code:
me![First Field].setfocus
If you are just moving from record to record, your "Tab Order" under the View menu for the form should control this; the focus should go the the first field.
If you are doing something special because a record is new (or not), then you have to specify the condition in the Form Current event.
I often use:
If Me.NewRecord Then ClassYear.SetFocus
- K-Squared
I know the code to use. Where do I put it?