Any idea how i can create historic view of the table/record so i can view any changes that have been made to a specific record?

For example...

I create a record. Later somebody comes and changes some of the data on this record. I would like to be able to view all the previous data before it was modified for this one record.

Any Ideas?

Hope that makes sense.

Mark

Search for "Audit Trail"

Col

Just to expand on what Colin said, there is no inbuilt history of data changes in Access, you have to create one yourself. That's what an audit trail is.

Thanks guys, found the audit trail and added it to my database, works great.

Mark