AutoAsign a data to a form field

[CharlieT302]

I have a VB code that assigns a date to a field. It is:
[Field] = Date

However, if the field already has a date, the command is ignored. Is there a simple way to always have the date replaced with the current system date even if a date already exists?

Thanks

 

[PHV]

In the Current event procedure of the form:
Me![field] = VBA.Date

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CharlieT302]

Thanks, I will give it a shot. The date, however, is being assigned as a result of a particular value being assigned using a drop down box. So, it is not always set. I was trying to set a date using the 'After Update' event.

I am assuming this wouldn't matter to the code...?

By the way, what is the difference between this code and the one I had?