Sounds like you want what's often called an audit trail. Search on that and see if looks appropriate.
Paul (wino moderator) MS Access MVP 2007-2019 www.BaldyWeb.com
Forum Rules