I would like to create a small function that will update a Memo field when values are changed but I am not sure how (or if it's possible) to carry a field's oldvalue and name into a function. The function I would like to write would need to be called by something like
and the function something like
Function fChangeLog(FieldName as Variant)
If FieldName.value <> FieldName.oldvalue then
me.History = Me.HistoryMe.History & vbNewLine & Me.LastEdited _
& FieldName.Name & " changed from " & FieldName.OldValue _
& " to " & FieldName.value
Is there a way to get this working?