I have an inventory form, and I have an add items form that allows to add an item, the received date, and the quantity.
After they enter the the amount, the latest received date and quantity appear in two textboxes on the inventory form.
This works, but if they add a date that's older than a date that was previously entered (such as if they forgot to enter an order), it puts that date in, not the latest date.
How can I fix this?
I tried using a query to use MaxOfDate, but I don't know enough in VBA to link to the query.