How to Emulate Split Form

[Gismo]

Here is the.mdb View attachment Splitform 1.mdb.accdb

 

[Gasman]

Not too worry, I finally got my version to work.
For some reason it was not recognising my subform control and for the life of me I could not see why.

Colin,

Any chance you could upload that DB in a 2007 friendly format please.?

 

[Gasman]

Gismo,

Have a look at your DB now.
You complicated matters by having the master form as a subform.

 

[Gismo]

Awesome, works like a dream, thank you very much for your help

 

[wcstarks]

I tried to implement the Form_Open() property as indicated, but it doesn't work for me.
My main form is a NavigationSubForm, Assets.
My Continuous Sub-Form is Asset_Groups
Both are using the same table.

The subform is linked to the master based on a common text field called Group. It shows a list of all other assets which have the same value in Group

I suspect the syntax for your solution needs to be modified to account for NavigationSubForms, but I don't know how to do that. Can you?

 

[Gasman]

I believe the key to the ESF (Emulated Split Form) is NOT to have linked fields as you would normally do for a form/subform.

It is all done in the main form open event.

    Me.RecordSource = "qryEmails"
    Me.sfrmEmails.SourceObject = "cfrmEmails"
    Set Me.sfrmEmails.Form.Recordset = Me.Recordset

I have still only used the most basic ESF, but that works fine for me.

HTH