Form Help With Text Boxes

[andylooney]

Hi,

I have a form that displays fields from a table called "supp", e.g "name", "address 1" etc etc.

i want to if possible when i change the text on the form that is already in "name" field or regardless any text box field on the form, i.e "ab" to "cd" to display on the form that that specific record has been changed by putting the word changed with the current date into the table "supp". also if nothing has been changed that do not put changed and the date.

Thanks

 

[bonekrusher]

due a search for "Audit trial" It keeps track of all changes.... hope this helped.