By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

After insert of date how to auto jump to next field

P: n/a
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

Dec 31 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"AA Arens" <ba***********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
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.


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
Dec 31 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.