tracking data entry date

[leeroi]

I would like to be able to determine when (mm/dd/yy) data is entered into an empty field in a form. Is there a way to do this?

 

[Eupher]

leeroi,

I'm not entirely clear on what you want to do. Is it:

1) Keep a running log of when data is entered or modified?
2) Track the last time a record is edited?
3) Keep track of when a record is created?
4) Is this for the entire record, or a specific field?

Give us a few more details and we can probably get you pointed in the right direction. For now, I would take a look at the Dirty event and the Now() function. Also BeforeUpdate and AfterUpdate.

HTH,

Ken S.

 

[leeroi]

I want to know when data is entered for the first time into a specific field, of an already created record.

 

[TheAceMan1]

leeroi . . .

Is it possible the [blue]InputMask property[/blue] will solve your needs?

See Ya! . . . . . .

 

[leeroi]

Hmmm. I don't see how I could use that.

 

[TheAceMan1]

leeroi . . .

You can't trigger a controls [blue]BeforeUpdate[/blue] or [blue]AfterUpdate[/blue] event unless the data passes the [purple]Input Mask formatting rule![/purple]

See Ya! . . . . . .

 

[obli]

Try looking at the AuditTrail database sample at

http://www.rogersaccesslibrary.com/