Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Subform not growing

Show all headers | View raw

On 02/02/2015 19:20:47, Larry Linson wrote:
> On Sun, 1 Feb 2015 09:55:02 GMT, "Phil" <phil@stantonfamily.co.uk>
> wrote:
> 
> 
>>The point is that the SubInvestments subform grows to the correct size if the
>>LinkMaster field is set to the Supplier (Main form) AccID, but not when the
>>LinkMaster field is set to the SubSupplier (Sub form) with
>>Forms!Suppliers!SubSuppliers!AccID.
> 
> If the spelling inconsistency (SubSupplier vs SubSuppliers) is just a
> typo, look at the following:
> 
> I think perhaps the intuitiveness of Access references may be part of
> the problem. There is no "SubForm" object in Access; there is a
> SubForm Control and you may display a Form in the SubForm Contro, but
> that Form is not part of the Forms Collection.
> 
> If the SubInvestments Subform Control. is located in the Main Form
> (that is, on the same 'level' as the SubSupplier, you might have
> better luck with Forms!Supplier!SubSupplier.Form!AccID which can be
> read in the Forms Collection, in the Form displayed in the SubSupplier
> Control, in the default Collection (that is "Controls"), in the AccID
> Control.
> 
> When I have difficulties with SubForm Controls, I often can solve them
> by going back to the basics of how Access interprets references. My
> suggested solution may or may not work for you, but it may be worth a
> try and/or some further examination.
> 
>>I have got over it, using the following after ReQuerying the SubInvestments
>>Subform
> 
> That's a lot of work to get the UI to behave as you want it to, but
> having the UI behave as the users want it to makes for user
> satisfaction. I can remember, back in a "previous incarnation as a
> mainframer", asking my manager if I could justify putting in some
> effort on what I thought was a possibly-questionable request, and the
> response was "Of course, that's a customer sat issue!"
> 

Thanks for coming back

Yes bothe subforms are at the same level.
It doesn't seem to matter whether the LinkChild field is
Forms!Supplier!SubSupplier.Form!AccID or Forms!Supplier!SubSupplier!AccID.
Guess I will just have to live with my botch which works, but slows things
down as it has to redraw the SubInvestments subform.

Phil

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

Back to comp.databases.ms-access | Previous | Next — Previous in thread | 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