If current record is new record, grab the focus
Private Sub Form_Current() If Me.NewRecord Then Me.txtContactFirstName.SetFocus End If End Sub