Updating table with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a macro that will update a table tracking when a
database has been refreshed with new data. In other words, would like to at
the current date/time in a field titled "update".

This sounds like a simple problem, but I cannot get this to work.

Can anyone help?

Thanks and kind regards

Jim
 
Jim,

Well, it really depends what you mean by "when a database has been
refreshed with new data". If you are editing records on a form, then
you would use a SetValue action in a macro assigned on the Before Update
event of the form. This would be like this:
Action: SetValue
Item: [YourDateField]
Expression: Now()
 
Back
Top