Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2006
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SalesOrder (Access97)

    I want QtyAvailable for sale from Inventory form show up on another form. I tried using SetValue and and works but only for the record that I'm pointing at the time in Inventory. What I want is for the sales person to be able to look at a product in the SalesOrder form and know how many are leftThis way, if there aren't any in stock, the salesperson won't make the transaction.

    Thanks,

  2. #2
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SalesOrder (Access97)

    As a suggestion to get started, you may want to look at Allen Browne's web site and in particular this link within his site Inventory Control: Quantity on Hand
    I used this as a "template" for our Parts room supply db.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

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