I have a few problems with it, that I can live with for now.
1. I am unable to select a different record some times until I use the record selector as opposed to just selecting a control.
2. When going to form view from design view I get error 2455 on the line shown in 2455-2 pic. If I End and try again it works fine, and does so for the most part. Obviously when running the user will not have design mode, but I would still like to know what my mistake is.

However I have just discovered that if I try and edit a record in the emulated splitform, I get the message in Emulated Splitform pic.

I tried the same on Ridders latest sample db with this with the same result.?
I would like to be able to use the datasheet as a normal datasheet if at all possible, just for ease of update on most occassions.

I've just checked the most recent version (v3) that I posted to the forum on 6 Aug

None of the issues you reported occurred for me (Access 2010 32-bit)

If you want to upload your problem split form, i'll have a look at it

__________________
ColinAccess 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., Tapatalk

If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

You're right about the CancelUpdate error when trying to edit a record in the continuous form section. Not sure whether its solvable

I realise you can edit both halves in the 'proper' split form but as you know that has lots of issues

I THINK the issue is caused by the fact that the 2 halves of the form are deliberately not linked with master/child fields. That's necessary to ensure all records appear in the continuous section.

A recordset is used to display the data in the main form which means you can't edit the subform

I tried changing it to recordset.clone - it then allows editing in the subform but its not updated in the top half.

I then tried requerying the main form but that gives a new error

As I never use split forms ... including my own emulated version ... I'm going to leave it for now

HTH

__________________
ColinAccess 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., Tapatalk

If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

I've just tried the form in my SSAFA database at home that is based on this logic, and whilst I still cannot edit any data in the subform, I do not get the error. ?
As the subform is really only used in this DB for selecting, that is not an issue.

__________________
ColinAccess 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., Tapatalk

If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Colin,
I was getting that 'stuck on a record' in the subform again this morning.
I amended your DB to make it a datasheet (as are mine) and can replicate the problem.?

If you have any time, would you be able to give it a look please.?

It doesn't happen all the time, so you will need to pretty much click in the subform randomly until it does. Should not take long.
To get past it then select the record selector. Even the vcr buttons on the bottom do not work.

I'm guessing it's because you have the same recordset effectively open twice, and one has to take precedence over the other.

__________________
A little thanks goes a long way To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

I've had another look at this and made some changes in the light of recent comments
There are 2 versions attached:

Version 4
a) the subform is now a datasheet rather than a continuous form

b) after editing a field in the top half it automatically does the following using an UpdateChanges procedure
- turns off screen updating
- moves to the next record
- moves back to the previous record
- moves to the next field
- turns on screen updating
Result: Both halves of the form update synchronously

c) I did exactly the same to the lower half and it can SOMETIMES be edited without the 'Update or CancelUpdate without addNew or Edit' error
For anyone who cares this is error 3020

The error is due to the way the recordset has been used in this emulated form.
I haven't been able to isolate it effectively but perhaps someone else will see how to do it.

__________________
ColinAccess 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10, To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts., Tapatalk

If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!