If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto fill certain fields in a data entry form Access 2003
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? |
#2
|
|||
|
|||
Auto fill certain fields in a data entry form Access 2003
cbianco wrote:
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. -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Auto fill certain fields in a data entry form Access 2003
Thank you, but that puts today's date which is not necessarily the date I
want to use. "PieterLinden via AccessMonster.com" wrote: cbianco wrote: 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. -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Auto fill certain fields in a data entry form Access 2003
You can set the default of a control in its after update event. Try something
like: Me.txtDate.Default = "#" & Me.txtDate & "#" -- Duane Hookom Microsoft Access MVP "cbianco" wrote: 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? |
#5
|
|||
|
|||
Auto fill certain fields in a data entry form Access 2003
.... and the date you DO want to use is ...?
Regards Jeff Boyce Microsoft Office/Access MVP "cbianco" wrote in message ... Thank you, but that puts today's date which is not necessarily the date I want to use. "PieterLinden via AccessMonster.com" wrote: cbianco wrote: 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. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|