Solved Split Form as subform

[Kayleigh]

Hi,
Would like to create a subform with a variety of info based on two related tables. Since one table has static info and the other has more continuous data, I believe a split form would work best - displaying datasheet against form-based data. However don't know if this is possible as a subform?
From what I understand a split form must all be from the same data source so I would need a query to include data from both tables?
When researching this (in particular this post) I found that it may be better not to use the default split form - what is advisable?
Thanks

 

[MajP]

Maybe you can mock this up without any data and show that. There is not enough information to provide a solution, but from what you said you may be able to do this just with a plain subform. Nothing in your post described why a split form. But definitely look first at the emulated split form.

Emulating the split form

Like many users of this forum, I abandoned split forms a long time ago as I found them difficult to adapt if you want to modify them in any way In a recent thread another user wanted to keep the idea but to emulate it using a single form with a continuous subform. See this thread...

www.access-programmers.co.uk

But even that level of detail may not be needed.

 

[theDBguy]

Hi. Not sure if you need or don't need a Split Form, but I don't think you can embed a Split Form as a Subform anyway.

So, if you can display the data you need using a Split Form alone, then I guess that's okay. Otherwise, you may have to use a regular Form/Subform setup instead.

Just my 2 cents...

 

[Kayleigh]

Yes it seems so as I've tried it various ways and it only displays one part of the form. It seems the only option is to to a continous form as a nested subform?
I have enclosed database (v similar to my recent post) - it is the subform on frmStaff which I would like to have some data displayed as input fields as well as some related data as datasheet view. Any ideas?