Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Unanswered: how to update a stock quantity from a form?

    we're having an issue with trying to update our quantity in a parts table from an order form that should remove the parts sold from the qty of the parts table.

    we would like an after update macro or a query that may assist us to do so.

    we tried an update qry with this code

    [Part Details]![Stock]-[Forms]![Order Details Subform]![Quantity].[Text]

    but it changes all qty for all parts.

    thanks for any help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    put a where clause onthe SQL to limit the update to the sepcified rows.

    eg
    UPDATE mytable, SET mycolumn = thisvalue WHERE acolumn = something
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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