I have a form used to update my printers database. I use the record selectors to update the database, as most people do. When I click the add new record button(>*) I want it to put the focus on the first text box. When I click the >* button it stays in the box where the cursor was before I clicked the >* button. Is this going to take VBA code?

Hi,

You can use VBA code to set focus to the text control. It´s quite easy. Just put the following code to Forms´s OnCurrent event:

Private Sub Form_Current()
    If Me.NewRecord = True Then
        txtControl.SetFocus
    End If
End Sub

You can also use the Properties>Tab Order dialog box. This should set the focus on the item at the top of the list.

mmcdonal