Split Form w/Subform - Romove subdatasheet

Question

Using a split form in Access 2007, datasheet on the bottom.  On the 'main' portion, I have placed a subform.

Since adding the subform, the 'datasheet' portion of the split form now includes the capability to display a "subdatasheet", it added the column with the little plus sign.  Clicking the + sign shows the subform.

I want to get RID of the subdatasheet entirely, do NOT want the column with the plus signs to be an option.

The form is based on a query, the "Subdatasheet name" property of the query is BLANK/Null.  The query is based on only one table, that tables "Subdatasheet Name" property is set to [None].

I believe this a unique problem due to placing the subform on the 'split form' in Access 2007.  ANY input is appreciated... Thanks!

Answer 1

I Had this same issue. To Keep it Simple, You said your subform was hidden. I just took my subform reduced it down to a icon size. Set Visible property "No" and dragged it into the Form Header Column. The plus signs went away, but was still able to use the subform info for the math. That's my Idea..

Answer 2

Please don't piggyback your question on another thread. Please use the Participate link above to start your own thread. You can include a link to the older thread if you want.

Answer 3

Is there a way to do this while keeping the subform visible? If not, how can I change the order that subforms appear in the split form datasheet view? I have two bound subforms and only one appears in the split form datasheet view; the "wrong one".

Answer 4

No, that does not relate.  I can see where you might think it does.  It's the 'subform' on the main partof the split form that is causing the 'subdatasheet' to appear.  The subform is completely unbound, no data source.  Setting the table used as the recordsource for the form does not resolve the issue.

To see exactly what I mean, do the following:

1. In a new ACCDB create a simple table.  Make sure the [subdatasheet name] property is set to "None".
2. Create a subform with no recordsource, put a lable on it or something...
3. Create an autoform of the table created in #1.  Add in the subform from #2.  Make sure the default view is split form. Open the form and you'll see the 'subdatasheet indicators' for all the rows in the 'split part'... Click on  one and the actual subform appears.
4. THAT is what I am trying to get rid of.

Any Ideas?

Thanks!

Answer 5

See ACC2000: Slower Performance on Linked Tables - 261000  andSlow performance on linked tables in Access 2002, in Office Access 2003, and in Office 2007 for code on how to remove that property.   You will likely need to run that code in the backend MDB.  Also you may need to run it occasionally.