Total from SubForm to MainForm goes to 0

Discussion in 'Microsoft Access' started by Guest, May 1, 2005.

  1. Guest

    Guest Guest

    When ever the Subform entrys exceed the viewable length of the Subform to
    total from the subform goes to "0" when you leave the record and come back to
    it.
    While entering information it properly posts the correct total of the
    subform to the mainform field. When you leave that record and come back the
    subform total goes to "0". I think because it can't see all or the last
    record in the subform. Does someone know how to fix this problem.
    --
    Thanks,
    KLDold
     
    Guest, May 1, 2005
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Hi KL,

    If you send me a private e-mail message, with a valid return address, I will
    send you write-up that I have available for displaying totals from a subform
    on the main form. Without knowing how you approached this problem, it's kind
    of hard to provide troubleshooting advice.

    Tom

    QWaos168@XScom cast. Dnet (<--Remove all capitolized letters and spaces).

    http://www.access.qbuilt.com/html/expert_contributors.html
    _______________________________

    "KLDold" wrote:

    When ever the Subform entrys exceed the viewable length of the Subform to
    total from the subform goes to "0" when you leave the record and come back to
    it.
    While entering information it properly posts the correct total of the
    subform to the mainform field. When you leave that record and come back the
    subform total goes to "0". I think because it can't see all or the last
    record in the subform. Does someone know how to fix this problem.
    --
    Thanks,
    KLDold
     
    Guest, May 1, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sandra Daigle
    Replies:
    0
    Views:
    767
    Sandra Daigle
    May 22, 2004
  2. John S. Ford, MD

    filtering a mainform using data from a field in a subform

    John S. Ford, MD, Nov 8, 2004, in forum: Microsoft Access
    Replies:
    2
    Views:
    270
    Allen Browne
    Nov 8, 2004
  3. Replies:
    2
    Views:
    268
  4. John S. Ford, MD

    Using DoCmd.OpenForm method with a mainform and subform

    John S. Ford, MD, Mar 27, 2006, in forum: Microsoft Access
    Replies:
    1
    Views:
    413
    Ken Snell \(MVP\)
    Mar 28, 2006
  5. Ernesto

    SubForm update MainForm

    Ernesto, May 8, 2006, in forum: Microsoft Access
    Replies:
    7
    Views:
    236
    Ron2006
    May 9, 2006
  6. Guest
    Replies:
    0
    Views:
    267
    Guest
    Jun 2, 2006
  7. Replies:
    0
    Views:
    748
  8. Hector
    Replies:
    3
    Views:
    587
    John W. Vinson
    Sep 25, 2009
Loading...