Split form record selectors

[InFlight]

Is it possible to hide the record selectors on a datasheet in a split form.
They have a + and when you click on them it shows the sub form which i don't want them to use through the datasheet as it has code on some of the fields.
Thanks

 

[June7]

I am not getting the + because there is no subform on split form.

If you don't want users to see subform then why have one? You want them to edit subform only from single record section? I don't think the + can be eliminated when there is a subform nor record selectors turned off in datasheet section.

 

[Deleted member 147267]

that image looks like that of a table with a sub datasheet. If I cycle record selectors on/off on a split form, they only show/not show on the single record portion and not the data sheet portion. I don't think I've ever seen + and - signs on a split form. I don't see record selectors in your image either. Taking all that in consideration, are you sure what you've posted is an image of a split form?
EDIT - if you said this was a sub form where the source object was a table instead of a query, and that table had a sub datasheet, then that might explain it. However, I don't think I have ever constructed that combination.

 

[June7]

@Micron, a subform on split form is possible and the +/- will display in datasheet section, exactly as shown in the image.

 

[InFlight]

I have a main form on which is 3 sub forms.
These are selected by the labels at the top
Exhibitors, Birds an memberships.
Pics attached.

Users click in the split form to get the exhibitor then fill in the data as required

when the + is clicked the pic "subform" is what happens. in a table it would show the exhibitors birds.

 

[arnelgp]

no possible to program that part.
its for table view only and it is not a split form.
its a sub datasheet.

you can remove it on table design.
blank out the Subdatasheet Name on the property sheet.

 

[InFlight]

blank out the Subdatasheet Name on the property sheet.

How would i do that

 

[arnelgp]

on design view of your table->Property Sheet.

 

[InFlight]

I set it to none, but didn't work

 

[arnelgp]

is it the correct table coz I just tested it.

 

[theDBguy]

I have a main form on which is 3 sub forms.
These are selected by the labels at the top
Exhibitors, Birds an memberships.
Pics attached.

Users click in the split form to get the exhibitor then fill in the data as required

when the + is clicked the pic "subform" is what happens. in a table it would show the exhibitors birds.

Hi. The closest thing I could suggest is to set the Subdatasheet Height property to 0.0007"


Hope it helps...

 

[InFlight]

I did try with a list box but got a few errors and problems. I will try again
Thanks every one