No Current Record error when closing forms (1 Viewer)

Albie0803

New member
Local time
Today, 16:23
Joined
May 11, 2022
Messages
2
This morning, all the FE dbs are now throwing a No Current Record error when closing some of the forms in the DB.

Everything was running fine yesterday afternoon.
No changes have been made to any code of the affected forms for at least a month.
The BE db has had Compact and Repair done on it.
I have put a break point on the last line of code ( Exit Sub ) in the forms.close statements and the code runs fine to there, but when I press F8 or F5 the form closes and the error message appears.
I have looked at all tables referenced by the affected forms and all the data looks ok.
Every other function on the forms works just as it did yesterday.

Office 365 2204
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 10:23
Joined
Feb 28, 2001
Messages
22,815
That version of Office is apparently throwing errors. You are not the first person to report the error. Can you try to roll back that Office update as a test?

If rolling back the 2204 update helps, try to stay at that lower version until the next Office patch comes out. As many reports as have come out on that problem, I think MS is aware of it and will hopefully do something constructive quickly.
 

mrtommo

New member
Local time
Today, 16:23
Joined
May 11, 2022
Messages
2
I've had the same error the past three days. Like the OP we didn't change anything else. Even opened up an old DB version with it's old Backed from 2 years ago and had the same issue. Not seen it before this week.
 

Minty

AWF VIP
Local time
Today, 16:23
Joined
Jul 26, 2013
Messages
9,288
It's a recently introduced bug - see the longer thread here:

And read about it here
 

mrtommo

New member
Local time
Today, 16:23
Joined
May 11, 2022
Messages
2
Thanks, Minty; that's great. I've reported it in the app to add to the pile; hopefully they'll fix it soon. It's not too bad for us, so can live with it until then. Just glad to know it's not anything I've done!
 

BillDodd

New member
Local time
Today, 16:23
Joined
Dec 11, 2007
Messages
4
This morning, all the FE dbs are now throwing a No Current Record error when closing some of the forms in the DB.

Everything was running fine yesterday afternoon.
No changes have been made to any code of the affected forms for at least a month.
The BE db has had Compact and Repair done on it.
I have put a break point on the last line of code ( Exit Sub ) in the forms.close statements and the code runs fine to there, but when I press F8 or F5 the form closes and the error message appears.
I have looked at all tables referenced by the affected forms and all the data looks ok.
Every other function on the forms works just as it did yesterday.

Office 365 2204
I too have had this issue. I tried a database written in 2011 and the form still gives the error of 'No Current Record' theres obviously been an update that now throws this error for some situation. It cannot be trapped. Access version 2204 15128.20224. It is a complex form - memory issues?

It does not appear to cause any issues, just gives the error message when closing the form.
 

GinaWhipp

AWF VIP
Local time
Today, 11:23
Joined
Jun 21, 2011
Messages
5,881
Issue *appears* to be fixed by running Update Now, at least for me and my clients whose machine automatically ran the update in the background.
 

Users who are viewing this thread

Top Bottom