Please Help!! Automatically updating a field in a table.

[RexesOperator]

I remember someone's signature (I paraphrase a bit here):

Tables store data
Queries sort data
Forms enter data
Reports print data
Macros and Modules do stuff

A nice little mantra to use.