Results 1 to 3 of 3
  1. #1
    Amyfb is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    64

    how to update table with value from calculated form field?

    in attached db, frmDocuments, is a tabbed control with a pgVersion. (credit and thanks to Mike Smart for the help to get this far)


    A command button "Add new Version" currently creates a new version with Version and revision number at 0 and 0.

    I want the new version records to have the Version and REvision fields to be one of two possibilities based on choosing Major or Minor.

    All I have been able to accomplish is a calculated field that provides the new value choices based on the current record values. I want the Major or Minor button to add a new version with the calculated values populated into the table for VErsion and REvision.

    How do I go about doing this?

    thanks
    AmyDocumentControl_PB.zip

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can update using the textbox on the form (use the fill path)
    set fld = forms!fMyForm!txtCalc

    or put the query with the formula
    set fld = qry.CalcFld

    or put in the formula:
    set field =( a+b+c)

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Amy

    Check and see if this version gets you any closer to what you need.
    Attached Files Attached Files
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 8
    Last Post: 03-26-2020, 03:43 PM
  2. Replies: 3
    Last Post: 01-08-2020, 10:11 AM
  3. Update calculated field on form
    By mommyof4kids in forum Forms
    Replies: 2
    Last Post: 08-23-2017, 07:39 AM
  4. Replies: 3
    Last Post: 02-13-2013, 10:15 AM
  5. Update table from calculated field in a form
    By BernardKane in forum Forms
    Replies: 3
    Last Post: 11-28-2006, 09:48 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