Neil wrote:
| 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?

Change SourceObject of the first subform instead:

Me.sfrm1.SourceObject = "frmFormB"


| 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?

DoCmd.OpenForm "FormA", acFormDS

--
KN