View Single Post
  #3  
Old June 2nd, 2010, 12:10 PM posted to microsoft.public.access.forms
Neil[_8_]
external usenet poster
 
Posts: 104
Default specifying which subdatasheet in Access 2003


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


You're saying that Access will always use the first subform as the
form's subdatasheet, and there's no way to speciy a different one
apart from changing the source object of the first subform control??

| 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


No, I mean when the subform is opened as a subdatasheet, not when it's
opened by itself.