Calendar To Stay at Last Date Entered

[Bill]

I have a calendar in a form. We do data entry for information that could
have occurred today, yesterday, or a couple of days ago, like over a weekend.
The form always goes back to todays date. How do I get the calendar to stay
at the last date entered?

 

[ruralguy via AccessMonster.com]

Somehow you will need to record the last date entered in a table somewhere.
I use a system table for such items.

 

[Bill]

I tried to add code to go to table, but it doesn't pull the last date. It
pulls a date two months ago. The code I wrote is:
Me!calsetdate.value = dlast("[INDEX_DATE]", "tblPROD_DATA")

The field is INDEX_NO
The table is tblPROD_DATA

I have this code once the form opens. Shouldn't it pull the last date in
the table?

 

[ruralguy via AccessMonster.com]

If it is the newest date then use DMax().

I tried to add code to go to table, but it doesn't pull the last date. It
pulls a date two months ago. The code I wrote is:
Me!calsetdate.value = dlast("[INDEX_DATE]", "tblPROD_DATA")

The field is INDEX_NO
The table is tblPROD_DATA

I have this code once the form opens. Shouldn't it pull the last date in
the table?

Somehow you will need to record the last date entered in a table somewhere.
I use a system table for such items.

[quoted text clipped - 3 lines]