Bean Machine
Member
- Local time
- Today, 18:59
- Joined
- Feb 6, 2020
- Messages
- 102
Hi Everyone! I have a query that pulls data from a table and allows the user to edit the amount of inventory on hand. They then have to change the "Date Updated" field to the day they changed the on hand amount. I was wondering, to make it a lot easier (since there are about 133 items and counting), can I make it so that when new data is entered into the "On Hand" field the "Date Updated" field auto populates the current system date to save a lot of manual work? Thanks for any help you guys can provide!