Track Data Change in a From

[Samer]

Hi All

what is the best way to track data change in a form previously entered and
save the changes to another table,

I done the following

in the form current event I assign the values of the textfield to variable
like

CFN = txtFirstName
CLN = txtLastName

and in the form before update event I check for data changes like
if CFN <> txtFirstName or CLN <> txtLast Name then
DoCmd.OpenQuery "Record_Name_Change" "Append Query"

if I test when I open the form with MsgBox CFN or CLN looks ok
but somthing wrong, before the update CFN and CLN is null values



Any Idea

Regards

Samer