Split form record selectors

InFlight

User
Local time
Tomorrow, 00:00
Joined
Jun 11, 2015
Messages
130
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
 

Attachments

  • Splitform.jpg
    Splitform.jpg
    65.8 KB · Views: 144
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.
 
Last edited:
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.
 
@Micron, a subform on split form is possible and the +/- will display in datasheet section, exactly as shown in the image.
 
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.
 

Attachments

  • Birds.jpg
    Birds.jpg
    102.6 KB · Views: 152
  • Exhibitors.jpg
    Exhibitors.jpg
    101.2 KB · Views: 146
  • Memberships.jpg
    Memberships.jpg
    74.5 KB · Views: 130
  • subform.jpg
    subform.jpg
    103.2 KB · Views: 233
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.
 
on design view of your table->Property Sheet.
 
is it the correct table coz I just tested it.
 
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...
 
I did try with a list box but got a few errors and problems. I will try again
Thanks every one
 

Users who are viewing this thread

Back
Top Bottom