Remove subdatasheet from Splitform grid.

Question

I have a split form. In the Form section, I have a sub form. The grid half of the split form displays with a Subdatasheet. When I click on the + button, the Subdatasheet expands to show the sub form tucked into each record on the grid. 

The record source does NOT have a Subdatasheet. 

Any recommendations on how to remove the Subdatasheet would be appreciated.

Thanks

Answer 1

Please let us know if it solves the problem.

Continued success with the project.

Answer 2

Thanks, I'll try it out.

Answer 3

I generally don't even use split forms, so this is possibly off target.

The Subdatasheet issue is possibly associated with the way your TABLES are actually set up. Check this:

By Default, Access sets this to [Auto], which often results in the kind of issue you describe, where a Child table is embedded in forms in DataSheet View.

Most experienced Access developers go out of their way to change that to [None] in order to avoid that problem. It is also reputed to maximize performance because it causes the records in that child table to be loaded, whether there's any value to that or not.

Selectively used, of course, this feature may have some value in appropriate circumstances.