Here is the.mdb
View attachment Splitform 1.mdb.accdb
How to Emulate Split Form (1 Viewer)
- Thread starter JamesJoey
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 06:58
- Joined
- Sep 21, 2011
- Messages
- 14,231
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.
For some reason it was not recognising my subform control and for the life of me I could not see why.
Last edited:
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?
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
Enthusiastic Amateur
- Local time
- Today, 06:58
- Joined
- Sep 21, 2011
- Messages
- 14,231
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.
I have still only used the most basic ESF, but that works fine for me.
HTH
It is all done in the main form open event.
Code:
Me.RecordSource = "qryEmails"
Me.sfrmEmails.SourceObject = "cfrmEmails"
Set Me.sfrmEmails.Form.Recordset = Me.RecordsetI have still only used the most basic ESF, but that works fine for me.
HTH