Automatically update field

[Cat]

In my Revenue datasheet form I want today's date to automatically fill in after the $$ amount is entered.

What is the best way to do this?

Thanks

 

[Rich]

set the default value to =Date()

 

[Cat]

That will put the date in automatically, but I only want date to go in if they enter a new revenue amount. They could just be looking at past entries.

Is there a way to tell Access after I enter this dollar amount, put today's date in the date field?

 

[Rich]

It will actually only put the date in when adding new records not when viewing existing ones.
Are you saying that there are other fields within the same record that have data in them and you only want the date added when one field is filled?
If so then use the after update event of that textbox to enter the date