Just hacking around with Access 2000 and will be using forms to update a variety of tables. I want to be able to record the time of change to each field in each table. Changes totables will take place through forms.

I'm sure people will have done this sort of thing before so some pointers would be welcome.

For example, a table might be a catalogue containing item names and item prices, with fields "name" and "price" respectively. I could add another two fields name_ch_time and price_ch_time to the table. The form would only show name and price.
In practice I'll have all sorts of tables and fields but I'd have a uniform naming convention for the changed time fields

My thought was to create a global module in which it's straightforward to grab the current form and the current control on an update event. But then I get a bit stuck. I want to do something like
...
Dim changeTime as String
....
changeTime = currentCtrlName "_ch_time"
currentForm!changeTime = Now()
...

I'm sure there must be away to substitute the value for changeTime rather than have it treated as a literal but I don't see how...

Thanks for any help, Richard.