Prev: solving a "ActiveX component can't create object or return referenceto this object Run Time Error 429"
Next: Installing/Upgrading Office 2010 - keeping Access 97
From: Neil on 1 Jun 2010 20:21
In Access 2003, I have a form with four distinct subforms. When I open
the main form in datasheet view, the first subform is available as a
subdatasheet.

1) How do a specify a different subform to be used as the
subdatasheet?

2) The subform originally opens in form view when the subdatasheet is
expanded and it appears. Is there a way to have it appear in
datasheet view instead?

Thanks.
From: Tom van Stiphout on 4 Jun 2010 01:42
On Tue, 1 Jun 2010 17:21:37 -0700 (PDT), Neil <nrgins(a)gmail.com>
wrote:

Eh, set the SourceObject of the subform control?
Tell us if I'm missing something.

-Tom.
Microsoft Access MVP


>In Access 2003, I have a form with four distinct subforms. When I open
>the main form in datasheet view, the first subform is available as a
>subdatasheet.
>
>1) How do a specify a different subform to be used as the
>subdatasheet?
>
>2) The subform originally opens in form view when the subdatasheet is
>expanded and it appears. Is there a way to have it appear in
>datasheet view instead?
>
>Thanks.
 | 
Pages: 1
Prev: solving a "ActiveX component can't create object or return referenceto this object Run Time Error 429"
Next: Installing/Upgrading Office 2010 - keeping Access 97