Question regarding sub-sub datasheet form

[terdfurgeson]

Is is possible to have a sub-sub datasheet "open" (expanded), but not visible?



The attached images show my issue somewhat. The data on the screen is used to feed a form that is faxed by VBA, removing much human interaction. (This part works great...)

The report works IF the sub-sub form is expanded, but not if it is collapsed. I'd like to remove redundant clicking and either auto-expand the sub-sub, OR if there is a programmatic approach that would better serve this, I'd gladly approach it that way.

I tried combining the alternatives in the first subform, but it must remain editable, as the checkboxes drive a recordset that controls what faxes to send.


Any ideas or suggestions would be highly appreciated.

[hansendl]

Try using the Form.SubdatasheetExpanded property to expand the subdatasheet on form opening.

[terdfurgeson]

Perfect. That was it. Ended up having to use the following structure to get it completely there:

Me.[subform name 1].[Form].SubdatasheetExpanded = True