Not able to have split form in a subform?

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?

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.

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.

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.

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.