Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Sub form total to main form

    Can someone tell me how I carry a summed total from a subform to a the main form.

    I then want to use this subform total in a calcualtion against a summed filed in the main form.

    many thanks

  2. #2
    Join Date
    Mar 2002
    Posts
    192
    In the main form use the following syntax

    =myFormName!myTextFieldName

    or if there are spaces in your control names use the []. I.e.

    =[My Form Name]![My Field Name]

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    So simple but perfect!

    Thanks very much

Posting Permissions

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