Re: Recordset for queries

Tech-Archive recommends: Fix windows errors by optimizing your registry

I believe that it is possible to have UNBOUND subform controls - subforms not bound to specific objects.

Bas Cost Budde wrote:
Oh, as you mention that:
I used to use a tabcontrol with several tabs with subforms. On a larger database this became forbiddingly slow. So I pointed all subform controls to some dummy form (loads fast) and assign the SourceObject in the Change event of the tabcontrol (reading the required value from the Tag property that I set for that purpose). Drawback is that you don't have immediate subform communication ability then

David C. Holley wrote:

Yes it does work and I have used it quite frequently. You can even go so far as to change the source object and display a different subform (provided you change the master/child link fields if needed) 


.

Relevant Pages

  • Re: How to trap the previous record mouse-click ?
    ... mention at all of Subform Controls in the original. ... navigation controls -- some do so just because the nav bar is so small; ... However, this LPO ...
    (comp.databases.ms-access)
  • Re: How to trap the previous record mouse-click ?
    ... mention at all of Subform Controls in the original. ... navigation controls -- some do so just because the nav bar is so small; ... However, this LPO ...
    (comp.databases.ms-access)
  • Re: passing values between forms
    ... "Ken Snell " wrote: ... wrong names for the subform controls. ... <MS ACCESS MVP> ... You can check the Name property of the subform controls in the Properties ...
    (microsoft.public.access.formscoding)
  • Re: passing values between forms
    ... wrong names for the subform controls. ... "Ken Snell " wrote: ... You can check the Name property of the subform controls in the Properties ... My first form is frm_BasicData_BasicData, ...
    (microsoft.public.access.formscoding)
  • Re: Recordset for queries
    ... On a larger database this became forbiddingly slow. ... So I pointed all subform controls to some dummy form and assign the SourceObject in the Change event of the tabcontrol. ... far as to change the source object and display a different subform ...
    (microsoft.public.access.modulesdaovba)