Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2020
    Posts
    18

    Change value of table in Access by pressing a button on a form

    Hi, I'm pretty new to Access. I really only have about a month using it. I have a split form where I have created a button. Upon pushing the button I would like the "Qty" field of that highlighted record to be updated to something like "Qty = [Qty] - [Qty Pulled]". The "Qty Pulled" is a text box where I enter the amount that I want to have taken out. I've tried using various "Set Variable" options on the macro, I've tried conditional formatting on record and nothing seems to be working. I already have the button attached to a macro so that's why I'm trying to go that route instead of using a code builder but if you think it'd be easier to do it another way then I could try that. I would have to change some additional stuff though.



    Any ideas would be greatly appreciated and thank you so much in advance.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,330
    Most of us would recommend against trying to save the quantity on hand. We'd calculate it on the fly from transactions. An oft-posted link:

    http://allenbrowne.com/AppInventory.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Join Date
    Feb 2020
    Posts
    18
    That link helped and it's working now. Thank you so much!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,330
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 11-19-2017, 08:41 PM
  2. Replies: 2
    Last Post: 11-09-2017, 04:02 AM
  3. Replies: 4
    Last Post: 05-03-2017, 10:37 AM
  4. Replies: 3
    Last Post: 03-11-2015, 03:28 PM
  5. Replies: 4
    Last Post: 10-23-2014, 12:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums