Hi
I have some forms where I allow datasheet view. Those forms also have a tab control containing subforms.
When in datasheet view, there is a "plus" just to the right of the record selectors. If that is clicked, the first subform displays between the current datasheet record and the next.
My question is: how do I control which subform is displayed, and equally importantly can I prevent it displaying any subform? I.e. I only wish to see the subform when its parent is in form view, not datasheet view.
I appreciate this is different to a subdatasheet, as display of these subforms can't be prevented by using the menus: Home>Records>More,>Subdatasheet>Remove as that is disabled for these form's datasheet view.
I have some forms where I allow datasheet view. Those forms also have a tab control containing subforms.
When in datasheet view, there is a "plus" just to the right of the record selectors. If that is clicked, the first subform displays between the current datasheet record and the next.
My question is: how do I control which subform is displayed, and equally importantly can I prevent it displaying any subform? I.e. I only wish to see the subform when its parent is in form view, not datasheet view.
I appreciate this is different to a subdatasheet, as display of these subforms can't be prevented by using the menus: Home>Records>More,>Subdatasheet>Remove as that is disabled for these form's datasheet view.