Can't insert current date into existing record

[TSimonick]

Hi Everyone,

All I want to do is insert the current date into an existing record when a form opens. I use: Me![txtOrderDate] = FormatDateTime(Date, vbShortDate) with form event On Activate. Since the record already exists, the Default property doesn't work. I have tried events On Open, Got Focus, etc and none of them work. I have one form where this code works On Activate, but no where else. I cannot find any difference between this form and my other forms, and they are all referencing the same table (through similar queries). So for each record there is a field for Order Date, Receive Date, Use Date, etc.

I would really appreciate any ideas about this problem.

TIA,

Tom

 

[JohnLowell]

Try setting it in the On_Current event for the form.

 

[BillPower]

Is the AllowEdits property for the form set to "Yes".

Is the Query your Form is bound to updateable. To check this, open the query manually, see if you can type in a date.

If you set the Form's recordsource at runtime is Me![txtOrderDate] = FormatDateTime(Date, vbShortDate) coming after that.