Groups > comp.databases.ms-access > #10321

Subform not growing

From	"Phil" <phil@stantonfamily.co.uk>
Newsgroups	comp.databases.ms-access
Subject	Subform not growing
Date	2015-01-31 13:14 +0000
Organization	Aioe.org NNTP Server
Message-ID	<maikgm$bnk$1@speranza.aioe.org> (permalink)

Show all headers | View raw

I have a main form Suppliers with the Key AccID. 
I Have 2 continuous subforms, one SubSuppliers shows branches of the main
account the Master link being AccID and the Child Link MasterAccID. The other
subform SubTransactions, shows transactions for the branch accounts.

If (and this is the wrong procedure) I set the Master link to AccID and the
Child to AccID on the SubTransactions all works as expected, and the subform
grows & shrinks to accommodate the number of records.

If I do what is wanted, with the transactions set Master link to
Forms!Suppliers!SubSuppliers!AccID and the child link to AccID, it sort of
works but the subform won’t expand to accommodate all the records. On the
OnCurrent of theSubSuppliers subform I do a Me.Parent!
SubTransactions.Requery. The first branch has 3 transactions, the second 2
transactions and the third 7 transactions. When I move from one branch to
another, the SubTransactions subform stays the same height and shows just the
first 3 records, although the totals for the seven records are correct. There
is no vertical scrollbar showing either.

Is this a bug? Is there a work around?

Phil

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Subform not growing "Phil" <phil@stantonfamily.co.uk> - 2015-01-31 13:14 +0000
  Re: Subform not growing Larry Linson <larry.linson@verizon.net> - 2015-01-31 15:56 -0600
    Re: Subform not growing "Phil" <phil@stantonfamily.co.uk> - 2015-02-01 09:55 +0000
      Re: Subform not growing Larry Linson <larry.linson@verizon.net> - 2015-02-02 13:20 -0600
        Re: Subform not growing "Phil" <phil@stantonfamily.co.uk> - 2015-02-03 16:37 +0000
          Re: Subform not growing "Joan Wild" <joanwild@xplornet.com> - 2015-02-03 22:23 +0000
            Re: Subform not growing "Phil" <phil@stantonfamily.co.uk> - 2015-02-04 18:01 +0000

csiph-web