Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005

    Question Unanswered: Assigning value to an unbound field from a subform

    Hello there, here is the issue,
    I have a form with an unbound field [TotalYards] tha needs to be updated.
    The main form has 2 linked subforms, in other words.

    I need to update the [TotalYards] unbound field in the main form, with the sum of [TotalYards] in the SubForm2 table field.

    I have tried the following, but it doesn't work.

    I have [tmpTotalYards] unbound field in subform2 formheader section that adds the table field [TotalYards] eg: "=Sum(nz([TotalYards],0))", I've build an event in the control source of the unbound field of my mainform and point to the subform2 tmptotalyards unbound field, but it does not work.

    any ideas?

  2. #2
    Join Date
    Mar 2007
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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