Remove '+' from Split screen

[ECEK]

I'm struggling with this. I have tried to follow other solutions be I'm getting nowhere.

I just want to disable the subdatasheet '+' on my Split Form.

I have tried going to RECORDS then MORE then Remove subdatasheet but it's always greyed out.

My form is based on a query and is un-editable.

Thanks in advance

 

[arnelgp]

i think that in order to remove that is to edit the table and edit the subdatasheet there to none.

 

[ECEK]

Hj there Arnelgp
I have tried to do that on the underlying tables. The option is not available in the properties of the query that I'm using for the form

 

[June7]

Nature of split form. Doesn't matter if table property is set to [None]. If you add a subform the datasheet will have subdatasheet. Subform doesn't even have to be dependent data.

 

[isladogs]

Nature of split form. Doesn't matter if table property is set to [None]. If you add a subform the datasheet will have subdatasheet. Subform doesn't even have to be dependent data.

@June7
I disagree with the above

I never use split forms but was intrigued by the thread so I've just made several test split forms using:
a) single tables where I'd deliberately added a subdatasheet
b) queries based on the above
None of these showed a subdatasheet '+' in the split form datasheet

Although the OP didn't mention adding a subform, I then tried adding a subdatasheet table as a subform in the split form footer => still no subdatasheet '+' displayed

Finally I moved that subform to the form detail section & as I expected, I finally got a subdatasheet '+' on the split form.
BUT that's nothing to do with being a split form.
You get the same result with a datasheet form & a subform added in the detail section - which is of course a pretty stupid thing to do.

@ecek
All the above tells you is that you can have a query based split form with no subdatasheet.
However, I can't see any settings that you may have switched on that may have caused this effect.
There are 2 subdatasheet properties in the Format section as shown below but I doubt this will cause the effect

Several other things to consider
a) your split form may be corrupted. Try re-creating it from scratch
b) there is an emulated split form in this thread https://www.access-programmers.co.uk/forums/showthread.php?t=294421
There are various versions which were created to get round some of the defects of the built in split form. Use the one from post 6
The emulated split form can have a datasheet or a continuous form as preferred
c) scrap the split form and create your own form & subform
d) if you NEVER use subdatasheets, I have code to prevent these being shown in related tables. Let me know if you are interested

HTH

 

[June7]

Well, I also tested before posting but apparently not enough. Yes, get same behavior with a regular form displayed as datasheet - the + show when there is a subform in Detail section. See no way to prevent. I never use datasheet/subdatasheet design and never used split form with a subform. Generally avoid the split form although have used in a couple of very small dbs.

 

[ECEK]

Just to get this right then.

Create a split form based on a table. "frmTable1"
Select Design view.

Drag and drop a sub form "frmsubForm1" linked by ID onto theform.

"frmTable1" now has a little cascading "+" in the datasheet area.

It is my contention that you are not able to remove this !!

 

[isladogs]

I already tried that as part of my tests.
As already stated the only time I end up with a Subdatasheet '+' is by placing the subform in the detail section ... which is an incorrect thing to do.
The reason it is incorrect is that Access creates a subform for each record in the main form resulting in a Subdatasheet

Suggest you post an example showing your problem.

 

[ECEK]

So that's a no then !!!

The reason for this query is that the + detracts.

My main Split Form is based on a query (that involves calculations) and is not updateable.
I have replicated the updateable fields into a sub form and attached this to the detail area of the split form.

everything works fine except for the distracting +

 

[isladogs]

So that's a no then !!!

The reason for this query is that the + detracts.

I spent around half an hour yesterday testing different scenarios
I've made it clear when I do and when I don't get a Subdatasheet.
AFAIK I've already tested that scenario or something very similar.
How does it help for me to repeat the test if I get the same result?

Whereas you have the situation already so that's why it makes sense for you to upload it.

I also suggested various things for you to try in my first reply.
You haven't made any reference to them so I've no idea if you've tried them.
If you ignore my comments, there's little point me replying

 

[June7]

Colin has suggested you place the subform in form HEADER section, not DETAIL section.

 

[isladogs]

Colin has suggested you place the subform in form HEADER section, not DETAIL section.

Actually I suggested the footer section but either would fix this issue.
Anywhere other than DETAIL