Auto fill certain fields in a data entry form Access 2003

[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?

 

[PieterLinden via AccessMonster.com]

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?

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

 

[cbianco]

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

 

[Duane Hookom]

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

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

 

[Jeff Boyce]

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

Regards

Jeff Boyce
Microsoft Office/Access MVP