specifying which subdatasheet in Access 2003

#1

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.

#2

On Tue, 1 Jun 2010 17:21:37 -0700 (PDT), Neil <nrgins (AT) gmail (DOT) com>
wrote:

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

-Tom.
Microsoft Access MVP

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

specifying which subdatasheet in Access 2003

comp.databases.ms-access comp.databases.ms-access

specifying which subdatasheet in Access 2003 - 06-01-2010 , 07:21 PM

Re: specifying which subdatasheet in Access 2003 - 06-04-2010 , 12:42 AM