After insert of date how to auto jump to next field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 31 Dec 2005 14:39 GMT

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

Reply to this Message

Larry Linson - 31 Dec 2005 19:39 GMT

>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
[quoted text clipped - 3 lines]
> automatically inserted and the cursor jumps to the next field. So,
> without a push button.

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

Reply to this Message