Creating a History

[mwabbe]

Is there any way to make a db history. so that when information is changed say an address the information that was in the address field will not be overwritten. so that if there was any question about why information was changed the user could just veiw the history.

[pbaldy]

Sure; the term you want to search on "audit trail".

[mwabbe]

looked it up and it says i cant use forms to add records?

[pbaldy]

Who said that? I have several applications where I've created an audit trail, and I always use forms to add records.

[mwabbe]

did you use http://www.everythingaccess.com/tuto...an-Audit-Trail

when i try to add audType, audDate, audUser to the fields it wont let me save it due to an invalid field name

[pbaldy]

I have not used that particular method, but Allen's code is usually very good. Where exactly are you trying to add those? I see nothing wrong with those as field names.

[mwabbe]

just trying to add them as field names in design view of a form

[pbaldy]

Have you first added them to a table? They would have to be fields in the table underlying the form before you could add them as a control source.