Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: how to update existing record

    as you can prob tell by the title im new to all this.... anyway

    i need to make a stock control database where once created in the form i will have a button that says update stock when clicked a box would pop up saying "part number" when you enter the part number and click ok it would then come up "quantity" and you would enter the quantity but instead of creating new records it would update a record if there was already one with that part number. is this possible? also is it possible to enter into the quantity box a negative number so that this would "take away" parts from our stock? any help would really be appreciated
    thanks in advance

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes it's possible to make a "Stock Level Adjustment" command, but it should really be a command button on the stock item form imo. Then you don't have to prompt for a part number. You need only prompt the user for the adjustment and add it to your existing StockLevel field.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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