Results 1 to 2 of 2

Thread: Need Ideas

  1. #1
    Join Date
    Nov 2002
    Location
    Hamilton,Ontario
    Posts
    132

    Unanswered: Need Ideas

    Hi
    I have one form with some fields as Item Number and Description and Quantity. form has a button WORK ORDER, when i click on that it adds all these records into TABLE called WORKORDER and then displays WORKORDER form with all the records in table WORK ORDER.
    I want it to display only that record which it added when forms loads up.
    Any Idea how to do that? thank you for help in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    You could display the record with the latest date/time stamp.

    You could display the highest ID if you're using Autonumber.

    You could have a small scratchpad table containing the last Work Order(s) added to the system and use that to drive the display.

    Good luck,
    Bruce Baasch

Posting Permissions

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