After insert of date how to auto jump to next field

I have a button containing the VB command Me.Notes = Me.Notes &
Format(Date, "dd-mm-yyyy") to have a date filled in a field. I want it
automatically jump to the next field, after the date is inserted. How?


By the way, more nicer is that when I start a new record, the date is
automatically inserted and the cursor jumps to the next field. So,
without a push button.


Bart

Access 2003

re: After insert of date how to auto jump to next field

"AA Arens" <bartvandongen@gmail.com> wrote in message
news:1136039964.588304.294240@g44g2000cwa.googlegr oups.com...[color=blue]
>I have a button containing the VB command Me.Notes = Me.Notes &
> Format(Date, "dd-mm-yyyy") to have a date filled in a field. I want it
> automatically jump to the next field, after the date is inserted. How?
>
>
> By the way, more nicer is that when I start a new record, the date is
> automatically inserted and the cursor jumps to the next field. So,
> without a push button.[/color]

Set the default of the date control to =Date() for just the date, or =Now()
for date and time. With the form in Design View, on the Menu, View | Tab
Order to set the tab order to bypass the date Control.

Larry Linson
Microsoft Access MVP