Have access recall the last date entered in a form

[lobstah24]

OK...I'm new to MS Access but I am progressing pretty well. I've made a small and simple D Base for our church to track member donations. The form used to enter donations has 4 entry boxes...NAME...DATE...AMOUNT...and CATAGORY. Presently I have the date box autocomplete with the current date...which is nice if the secretary enters the donations the day of the service. But if she doesn't she has to change the box for each entry. There is a way (I believe) to only have to change it once and access will remember the last date you entered and make that the default date for the form. I could have sworn I've seen it in my Access for dummies book but I can't find it to save my life. I'm sure it's simple...

Anybody know how?...

Thanks in advance!

L24

[ADezii]

OK...I'm new to MS Access but I am progressing pretty well. I've made a small and simple D Base for our church to track member donations. The form used to enter donations has 4 entry boxes...NAME...DATE...AMOUNT...and CATAGORY. Presently I have the date box autocomplete with the current date...which is nice if the secretary enters the donations the day of the service. But if she doesn't she has to change the box for each entry. There is a way (I believe) to only have to change it once and access will remember the last date you entered and make that the default date for the form. I could have sworn I've seen it in my Access for dummies book but I can't find it to save my life. I'm sure it's simple...

Anybody know how?...

Thanks in advance!

L24

In your Date Field Properties, under the Data Tab, set the
Default Value as follows: =DLast("[DateFieldName]","Table Name")

[NeoPa]

Try setting the Default property of the DATE field in the table to "=Date()" (quotes not necessary when entering it in design view).
You may want to rename your Cat field to CATEGORY while you're at it ;)

[lobstah24]

In your Date Field Properties, under the Data Tab, set the
Default Value as follows: =DLast("[DateFieldName]","Table Name")

Thank you so much...it worked like a charm. I've been racking my brain for 2 hours.

[lobstah24]

I didn't see how to edit my previous post so I'll add another.

Just another thank you for the prompt response. I'll certainly add this site to my favorites and who knows...perhaps someday I can help someone else out...someday.

Thanks again...

[ADezii]

I didn't see how to edit my previous post so I'll add another.

Just another thank you for the prompt response. I'll certainly add this site to my favorites and who knows...perhaps someday I can help someone else out...someday.

Thanks again...

Our pleasure

[NeoPa]

I didn't see how to edit my previous post so I'll add another.

This site allows editing of posts for members for only five minutes after the post is originally submitted. Hence the lack of the link.
Otherwise, see ADezii's post for my reply :)