How to get cursor focussed on field field after new record?

I want the cursor focuses on the first field when starting a new
record. Now I have to use my mouse. How to solve it?

Bart
Access 2003

re: How to get cursor focussed on field field after new record?

AA Arens wrote:[color=blue]
>I want the cursor focuses on the first field when starting a new
>record. Now I have to use my mouse. How to solve it?
>
>Bart
>Access 2003[/color]

In the design view of the form look at the menu:

View>Tab Order

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1

re: How to get cursor focussed on field field after new record?

If you want the cursor in the control named InvoiceDate whenever you move to
a new record, add this to the Current event procedure of the form:

Private Sub Form_Current()
If Me.NewRecord Then
Me.[InvoiceDate].SetFocus
End If
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AA Arens" <bartvandongen@gmail.com> wrote in message
news:1136096268.289114.220690@g43g2000cwa.googlegr oups.com...[color=blue]
>I want the cursor focuses on the first field when starting a new
> record. Now I have to use my mouse. How to solve it?
>
> Bart
> Access 2003[/color]