Results 1 to 4 of 4
  1. #1
    Niyrho is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    5

    Update value in form

    I have a table listing various products. There is a form to enter and update those products. I'm having trouble updating the quantity field.

    I'm using a split form. I can select a product on the bottom of the form and it fills in all the fields in the top of the form with that products information. I want to add a text box, or something, where I can type in a quantity I received and when I click a button the form will add the received quantity to the previous quantity and update that record.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You should not be doing it this way.
    You should have a table for the product transactions, that records goods in and goods out. Then you just sum the number field.

    If you must do it your way, have an unbound field, that will accept the value and then add/subtract that control value from your total of product field on that record on the click event of that button.

    Now I've loaded the gun with live rounds, so beware.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    just use a normal form.
    edit the value, save.

  4. #4
    Niyrho is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2021
    Posts
    5
    Quote Originally Posted by ranman256 View Post
    just use a normal form.
    edit the value, save.

    The problem with that is I will need to also track how much is going out. What comes in is measured in ounces, what goes out is measured in a percentage of a whole which in some cases works out to fractions of milliliters. Can you do that math in your head?

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

Similar Threads

  1. Replies: 7
    Last Post: 07-19-2016, 05:28 PM
  2. Replies: 6
    Last Post: 11-05-2014, 05:27 PM
  3. Update Table after Record Update with Form
    By speciman_A in forum Forms
    Replies: 25
    Last Post: 10-31-2014, 01:00 PM
  4. Entry Update Form Problem with the update
    By cuddles in forum Forms
    Replies: 1
    Last Post: 05-30-2014, 02:38 PM
  5. Replies: 7
    Last Post: 09-21-2012, 11:09 AM

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