Auto Date entry

[racdata]

Hi
I need to know how to auto enter the date of the previous record into a new record.
I have this db for my vehicle log sheets and I submit monthly a claim for the business km from my company. I usually cant remember the date of the previous claim and have to scroll back until I find the field with a date. It will be useful if the date was copied into every new record until I edit the date when I submit the claim.
What I ask is during the new month all the dates will be the same until I submit the claim.
I do not know how to do this, and yes I have done a search.

 

[madefemere]

Hello,

I understand what you want but whithout the structure of your tables it's difficult to help you or guide you.
Can you give the structure of your DB (the tables and how you do your claims). If it possible to share a minimum of your DB here at ACCESS 2003 version.

 

[bob fitz]

racdata,

Try setting the Default Value property of the date text box on your form to:
=DMax("DateFieldName","YourTableName")

 

[racdata]

Thanks it work perfectly.