Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002

    Unhappy Unanswered: Latest Received Date on Form

    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.

  2. #2
    Join Date
    Feb 2002
    You could add a validation rule to the text box with >=Dmax("[RecievedDate]","tblInventory").

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts