Setting the focus in the tabbed pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The entry form of my database consists of a number of tabbed pages. After an
operator completes data entry for one record and
clicks the new record button to start data entry for a new record, the focus
stays on the last tabbed page where data entry was made.
This consequently leads to the necessity for the operator to return the
focus on the first tabbed page by scrolling the tabbed pages.
Is there any way I can set up the focus on the first tabbed page of the data
entry form after the operator clicks the new record button?
If so, what code do I need to write?
 
If you want to jump back to the first text box as soon as the user moves
into a new record, you could use the Current event of the form.

Example:
Private Sub Form_Current()
If Me.NewRecord Then
Me.[NameOfSomeTextBoxHere].SetFocus
End If
End Sub

I must say this is rather worrisome though. If you have "a number of tabbed
pages" to record one record, you probably don't have a normalized design.
 
Back
Top