specifying which subdatasheet in Access 2003
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
|