Results 1 to 4 of 4
  1. #1
    Compumakro is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2022
    Posts
    1

    Copy result of a SubForm to the Form

    Access Friends


    A help please.
    I have a "Remision" form with a subForm, "SubRemision"
    The Subform named SubRemision has a field called "CantidadRemision". (Here the number of units of a product is entered).


    At the bottom of the SubForm, I placed an independent field with the following formula: =Sum([Remittance Quantity]).


    So that it totals all the units entered in the field "CantidadRemision".


    This total must be displayed in the "TotalUnidadesRemision" field that is in the container form (Remision)


    This field "TotalUnidadesRemision" has the following formula:


    = Forms![SubRemission]![SumAmountRemission]. ......... But the result is ¿Name?


    What's wrong there....?


    thanks for your help

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

    Are you able to upload your database?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    I suspect that you are using the wrong syntax to reference a control on the subform. See: http://access.mvps.org/access/forms/frm0031.htm
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

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

Similar Threads

  1. Copy form then subform of a subform
    By Euler271 in forum Queries
    Replies: 9
    Last Post: 09-21-2018, 12:16 PM
  2. Replies: 3
    Last Post: 01-19-2017, 05:05 AM
  3. Replies: 1
    Last Post: 02-25-2016, 01:39 PM
  4. Copy a query result to a form
    By vgreen in forum Forms
    Replies: 3
    Last Post: 01-30-2013, 02:23 PM
  5. Replies: 2
    Last Post: 03-04-2010, 02:04 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