Auto fill certain fields in a data entry form Access 2003

  • Thread starter Thread starter cbianco
  • Start date Start date
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?
 
You can set the default of a control in its after update event. Try something
like:

Me.txtDate.Default = "#" & Me.txtDate & "#"
 
.... and the date you DO want to use is ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Access Project - Almost There Just Need Some Help... 2
Auto Fill in table 0
Access Daily Entry with multiple entries per field 0
Auto Complete field 1
Document number auto fill help 3
Simple data entry form 1
Hard-coded date in an Access Form 9
Access How to record date/time when specific field is modified in Access 2007 0

Back
Top