Forms![FormName]![SubFormName].Form.SubdatasheetExpanded = True - can be used to expand ALL of the SubDatasheets on your form.
However often you want only some of SubDatasheets to be expanded, based on some criteria (for example - expand only if SubDatasheet contains data..)
Download demo database attached to see how that could be done using Accessibility library.
Make sure you have added a reference for "Accessibility" library (%windir%\system32\oleacc.dll)
http://sites.google.com/site/msaccesscode/
Link to this comment:
All Comments (0)