Split Form Orientation...Coding?

[tylerg11]

I am redesigning forms to have a more compact and organized look. Currently, the split form view is used on all the main forms. Instead of the Datasheet portion of the split form in a separate pane, I'd like to put it on a tab in the pages control I've added to the form. There are only four options for the split form orientation property from the property sheet. i was wondering if I could use a little coding to put the split form orientation on a tab in the form itself?

[boblarson]

I thought I already gave you that answer. The answer is no, you can't do that. There is no way to do it. You would need to use a mainform, subform to simulate that.

[tylerg11]

But a split form lets you select a record which displays in the main form. How could you do that with a subform?

[boblarson]

But a split form lets you select a record which displays in the main form. How could you do that with a subform?

With coding and it would not have anything in the Master/Child links. The On Current event of the subform (datasheet) would have:

Dim rst As DAO.Recordset
 
Set rst = Me.Parent.RecordsetClone
 
rst.FindFirst "[IDFieldNameHere]=" & Me!IDFieldHere
 
If rst.NoMatch Then 
   msgbox "Error! Contact your IT Representative", vbExclamation, "No Match Found"
Else
   Me.Parent.Bookmark = rst.Bookmark
End If
 
rst.Close
Set rst = Nothing