Solved Can't exit subform (1 Viewer)

Kayleigh

Member
Local time
Today, 19:02
Joined
Sep 24, 2020
Messages
706
I have a weird problem. I have onChange event of one field which triggers a pop-out input form. When the input is saved, it should update the original form.
My issue is that when I return to the original form (which is a subform), I can't click out of the subform to save the changes. I tried so many options but currently the only way to is to force the form to close and I get an error message.
Is there any way to resolve this? (See DB enclosed)
 

Attachments

  • dbsTEST.accdb
    5.4 MB · Views: 108

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:02
Joined
Aug 30, 2003
Messages
36,125
How does one recreate the issue? There is no change event in VBA, so perhaps it's a macro?
 

conception_native_0123

Well-known member
Local time
Today, 13:02
Joined
Mar 13, 2021
Messages
1,834
when I first clicked on the combo box dropdown in the subform i got this error. not sure if that can help or not. but it looks like one too many deletions have occurred:

1.jpg
 

CJ_London

Super Moderator
Staff member
Local time
Today, 19:02
Joined
Feb 19, 2013
Messages
16,607
your control rowsource is qrylkpStaffAdmin - however your db does not include any queries
 

Kayleigh

Member
Local time
Today, 19:02
Joined
Sep 24, 2020
Messages
706
Sorted. It was an after update event which wasn't completed.
 

Users who are viewing this thread

Top Bottom