I have a form with 2 subforms (Access 2002). When switching to Datasheet View for the main form I get a nice little "+" icon next to the beginning of each row that when clicked pops down a "Datasheet subform" for one of my subforms.
How do I get 2 "+" icons so that both subforms can be displayed?
Only one subform (usually the last one added to the main form) is allowed to be displayed in Datasheet view of the main form.
Perhaps this isn't event possible, but would be a cool feature if it exists.
Fortunately there is a simple way to swap between subforms:
1. Include subform 'A' in the main form. Name it, for instance, 'DynamicSubForm'.
2. Put a TextBox 'Switch' on the main form, for example with a '>' in it. Put it anywhere you want, for instance as the first column. If You make it as wide as the column with the '+' in it, it looks like it is a system function.
3. Select the main form. Put VB in the 'On Open' event:
Me.DynamicSubform.ObjectSource = 'A'
4. Select the 'Switch' TextBox. Put VB in the 'On Click' event:
If Me.DynamicSubform.ObjectSource = 'A' then Me.DynamicSubform.ObjectSource = 'B' else Me.DynamicSubform.ObjectSource = 'A'
5. There are several ways to make it look even better. However, this solution works for me...
Hopefully they will add this feature in the future.
It's more likely they will remove it... considering how much they screwed Access over with 2007, where they removed several BIG things... such as Data Access Pages, Userlevel Security, Toolbars and Menus, just to name a few.