Date lookup

[John]

I have created a form for production data entry. The initial field is Date.
How do I get the form to display the last date entered into the table, so I
can continue where I left off and not have to re-enter the date every time I
enter a record?
Thanks

 

[fredg]

I have created a form for production data entry. The initial field is Date.
How do I get the form to display the last date entered into the table, so I
can continue where I left off and not have to re-enter the date every time I
enter a record?
Thanks

If the actual name of your date field is [Date], I would strongly urge
you to change it to something else, perhaps dteDate, RunDate, etc.
Date is a reserved Access/VBA word and should not be used as a Field
name.
Read Microsoft KonowledgeBase article:
109312 'Reserved Words in Microsoft Access'
209187 'Acc2000: 'Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'

To respond to your question,
Set the Default value for the Form's Date control:
=DMax("[DateField]","TableName")
Whenever you want to change to a new date, just write right over the
date shown.

 

[John]

Terrific information! Thanks so much!

I have created a form for production data entry. The initial field is Date.
How do I get the form to display the last date entered into the table, so I
can continue where I left off and not have to re-enter the date every time I
enter a record?
Thanks

If the actual name of your date field is [Date], I would strongly urge
you to change it to something else, perhaps dteDate, RunDate, etc.
Date is a reserved Access/VBA word and should not be used as a Field
name.
Read Microsoft KonowledgeBase article:
109312 'Reserved Words in Microsoft Access'
209187 'Acc2000: 'Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'

To respond to your question,
Set the Default value for the Form's Date control:
=DMax("[DateField]","TableName")
Whenever you want to change to a new date, just write right over the
date shown.