Like many experienced Access users, I abandoned split forms a long time ago as I found them difficult to adapt if you want to modify them in any way.
However many people still like the split form layout so this was done as a project to try overcome the difficulties inherent in the split form supplied with Access
Attached is a very simple application to show how it works.
It took many versions to work through various bugs before reaching this stage
Many thanks are due to the following members of Access World Forums for contributing to various stages in the development of the project:
a) Mark Klein (MarkK) - for suggesting the original code used in the Form_Open event
b) Arnel Puzon (arnelgp) - for providing code to highlight the selected row in the continuous form
c) Paul Steel (Gasman) - for testing various iterations in Access 2007 where there were additional issues
d) Static - for fixing a persistent error when moving through the recordset
Like the 'real' split form, the emulated split form (ESF) has a single form section at the top with a contnuous form at the bottom. However unlike the real split form, the data can be filtered as well as sorted.
Click the image to view a larger version ...