Mendip Data Systems

Database applications for businesses and schools


Example Apps for Businesses, Schools & Personal Use

Version 10.0      Updated 02/10/2017               Approx 0.6 MB


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 to download:  Emulated Split Form   (zipped)

Emulated Split Form  

Click the image to view a larger version ...


ESF Return to Example Databases Page