workaround for needing split form as nested subform in tab object

[rivereridanus]

Hello!

I am trying to essentially recreate a split form that will be nested as a subform in a tab object, since I can't actually nest a split form as a subform.... here's the general concept:

The picture with the blacked out lines is a split form, and is exactly what I want. The table portion has all the records in the table Issues, and when I click on one of the records, the bottom form is populated with that record. However, I need to nest this in a tab object, and can't do it because the datasheet portion goes away.

I have attempted to recreate this without a split form by making another form called frmIssueDataSheet which contains subforms frmIssue (the form) and [Issues subform] (the datasheet). frmIssue and Issues subform are both related to the master form (frmIssueDataSheet) on Master.ID=Child.ID, so what I'm getting -which you can see in the picture without the blacked lines- is that the table only displays the same record that is currently being displayed in the form.

Essentially what I would like to do is have the frmIssue be reliant on the Issues subform. However, when I tried to create frmIssue as a subform in Issues subform, the Issues subform is no longer a datasheet!





Please help if you know what I'm doing wrong or what I need to do! Any assistance is sincerely appreciated!

[June7]

A form in Continuous view can be made to appear as datasheet. But I am not sure that will help you here.

Maybe this is what you need http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[rivereridanus]

Maybe this is what you need http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

Yes! That is exactly what I needed! Thank you so much!