Some significant problems have been reported with the emulated split form.
AFAIK the problems only affect Access 2007
See this rather lengthy thread: https://www.access-programmers.co.uk...d.php?t=295803
In an attempt to deal with the reported issues, various changes have been made and alternative approaches suggested.
Version changelog attached for anyone who is interested
It seems to be impossible to create one version of the ESF that includes all features and works in all versions of Access.
Perhaps that is why the official MS split form itself has flaws....!
Anyway, attached to this are 2 versions as follows
These look very similar & mostly behave in the same way.
Please use/adapt whichever you prefer or works best for you
Based on the original idea suggested by MarkK
using a subform and linked recordsets
This uses a continuous subform - a datasheet version is also supplied as an alternative if preferred
Either version of the subform can be sorted by clicking on any of the column headers
Includes current record highlighting and record filtering.
Updating the checkbox requires two clicks when moving to a new record
Errors reported for at least one A2007 user
Occasionally triggers error 2105 if next or previous button clicked repeatedly very fast
Based on a different approach suggested by Static
All controls in the same form so no need for linked recordsets
MUCH simpler code than version 10A so easier to adapt by others
This SHOULD work in ANY version of Access AFAIK
Sorting and record filtering as for version 10A
Record highlighting removed as it didn't work properly
Same error 2105 issue can occur as for version 10A
NOTE: Full error trapping code has not been done in either version
Many thanks to others who've conributed to this topic
Particular thanks to MarkK, arnelgp & Static
for their suggestions & to Gasman
for providing feedback on A2007
I am intending this to be my final contribution to this topic.
However, I would be only too pleased for others to take this on and develop the idea further ....
Personally I NEVER use split forms - and that also applies to the emulated version!!!!