Not able to have split form in a subform?

**Quattro** · 02-09-2009

Hi,

i have this problem with my Ms Access form. Normally I can easily use a split form for controls & datasheet. But if I do the same on the subform I am not being able to do so. I don't know whether this is allowed or not or what is being wrong? Why am not able to have split form in a subform?

Is there any appropriate way doing this?

**Jhonwho** · 02-09-2009

I think you are correct with the question here. Even I have found this happening in access. From what I've read, it seems like the split form does not show up in Subform. I created only two Subform - with a sheet and a "regular" form and it works ok. It just seems odd that a split form can not be displayed on a Subform.

**spuff** · 02-09-2009

I have similar problems with controls that had changed from when the Current event of a split form does not update. I've found that changing the reference of, for example, the most lblTesting or Me.lblTesting to Forms! solves the problem.

**Arlo** · 02-09-2009

Microsoft answered my question. The split forms are not used when a Subform. I (and the tech support person) made a feature request. Although names or where they just lazy to form an opinion to have been shot Subform can not be viewed as an important part of access Subform properties.

**Maximilian** · 02-09-2009

No. It's not a bug it's just not possible to split for Subform as a main form. It's meant to be used as the main form. You could try to mimic it by itself though two Subform to the main form, with 1 for single form & other for datasheet view. Place the master child field the same would and you should have the same effect.