View Single Post
  #4  
Old June 2nd, 2010, 12:47 PM posted to microsoft.public.access.forms
Krzysztof Naworyta
external usenet poster
 
Posts: 80
Default specifying which subdatasheet in Access 2003

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

I can not find SubdatasheetName property in form properties, even in hidden
members...

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

Change its DefaultView if you can.
Or after opening it run this code:

Me.sfrm1.SetFocus
DoCmd.RunCommand acCmdSubformDatasheetView

---
KN