Split form record selectors (1 Viewer)

InFlight

User

Local time

Today, 15:10

Joined

Jun 11, 2015

Messages

130

• Jul 20, 2019

• #1

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

  65.8 KB · Views: 94

June7

AWF VIP

Local time

Yesterday, 19:10

Joined

Mar 9, 2014

Messages

5,463

• Jul 20, 2019

• #2

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: Jul 20, 2019

M

Micron

AWF VIP

Local time

Yesterday, 23:10

Joined

Oct 20, 2018

Messages

3,478

• Jul 20, 2019

• #3

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

AWF VIP

Local time

Yesterday, 19:10

Joined

Mar 9, 2014

Messages

5,463

• Jul 20, 2019

• #4

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

 

InFlight

User

Local time

Today, 15:10

Joined

Jun 11, 2015

Messages

130

• Jul 20, 2019

• #5

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

  102.6 KB · Views: 108
• 
  Exhibitors.jpg

  101.2 KB · Views: 100
• 
  Memberships.jpg

  74.5 KB · Views: 83
• 
  subform.jpg

  103.2 KB · Views: 170

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 11:10

Joined

May 7, 2009

Messages

19,228

• Jul 20, 2019

• #6

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

User

Local time

Today, 15:10

Joined

Jun 11, 2015

Messages

130

• Jul 20, 2019

• #7

blank out the Subdatasheet Name on the property sheet.

Click to expand...

How would i do that

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 11:10

Joined

May 7, 2009

Messages

19,228

• Jul 20, 2019

• #8

on design view of your table->Property Sheet.

 

InFlight

User

Local time

Today, 15:10

Joined

Jun 11, 2015

Messages

130

• Jul 20, 2019

• #9

I set it to none, but didn't work

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 11:10

Joined

May 7, 2009

Messages

19,228

• Jul 20, 2019

• #10

is it the correct table coz I just tested it.

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:10

Joined

Oct 29, 2018

Messages

21,449

• Jul 20, 2019

• #11

InFlight said:

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.

Click to expand...

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


Hope it helps...

 

InFlight

User

Local time

Today, 15:10

Joined

Jun 11, 2015

Messages

130

• Jul 21, 2019

• #12

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