Update Record Displayed in Form

[khill]

I have been able to get the following command to work from the form's "After Update" property.CurrentDb.Execute "UPDATE [Family Member Table] SET Changed = '" & CurrentUser() & " " & Int(Now()) & "' WHERE [individualID#] = " & Me.Individual & " "Is there a command that will update the current record displayed in a form? When I close the form or move to another record, I want the field "Changed" to be updated with '" & CurrentUser() & " " & Int(Now()) & "'Thank you, in advance, for your help,Ken Hill