Auto fill certain fields in a data entry form Access 2003

C

cbianco

I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?
 
P

PieterLinden via AccessMonster.com

cbianco said:
I want to enter some data in a form, hit the enter key and have the date
filled in for the next record and the focus set to the field below the date
field.

Any suggestions on how to accomplish this?
Click to expand...

Set the default value for the control to =Date() and leave it out of the tab
order.
 
C

cbianco

Thank you, but that puts today's date which is not necessarily the date I
want to use.
 
D

Duane Hookom

You can set the default of a control in its after update event. Try something
like:

Me.txtDate.Default = "#" & Me.txtDate & "#"
 
J

Jeff Boyce

.... and the date you DO want to use is ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top