Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Running an update query from a form

    I have a subform which records the item purchased, price, etc. I have a calculated field in the UnitsInStock field that will take the current units in stock and subtrack the quantity that the user order. I want to run an update query from a command button when they submit the order to update the tblProducts table with the new UnitsInStock number. When I use the expression builder for the command button, my query isn't listed. Is this the right way to go about it? I'm not sure that my query is set up right either, since I am using data from the form.


  2. #2
    Join Date
    May 2005
    Have a look here for putting VBA and SQL together, hope it helps!
    Me.Geek = True

Posting Permissions

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