adding record

[baz]

Hi,
Is there any way I can get the cursor to appear in a
specfic field in the form automatically after selecting
add record. At the moment the user selects add record
and then has to select the first field to input data.

regards baz

 

[Rick Brandt]

Hi,
Is there any way I can get the cursor to appear in a
specfic field in the form automatically after selecting
add record. At the moment the user selects add record
and then has to select the first field to input data.

In the Form's Current event ...

'To do it all the time
Me!SomeControlName.SetFocus

'To do it only on new records
If Me.NewRecord Then Me!SomeControlName.SetFocus