Solved Help! My query has stopped allowing new records to be added (1 Viewer)

slharman1

Member
Local time
Yesterday, 19:10
Joined
Mar 8, 2021
Messages
467
I have a form based on a query and a subform based on a query, the subform just started to refuse me to add new records,
Here is the properties for both forms:
data entry = no
Allow Additions= Yes
Allow Deletions = Yes
Allow Edits = Yes
Allow Filters = Yes

When I run the qry by itself there is no *New line at the bottom either.
I can figure this out.
 

Isaac

Lifelong Learner
Local time
Yesterday, 17:10
Joined
Mar 14, 2017
Messages
8,738
Your query has become non-updateable. Non-updateable queries can be because there are aggregates or because of the joins situation. Try basing the form(s) on a simple query with fewer tables involved.
 

slharman1

Member
Local time
Yesterday, 19:10
Joined
Mar 8, 2021
Messages
467
Thanks TheDBGuy and Isaac, you were both correct, I have an aggregate query in the mix for the sub form.
Problem solved.
 

Isaac

Lifelong Learner
Local time
Yesterday, 17:10
Joined
Mar 14, 2017
Messages
8,738
Glad you got it working!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:10
Joined
Oct 29, 2018
Messages
21,358
Thanks TheDBGuy and Isaac, you were both correct, I have an aggregate query in the mix for the sub form.
Problem solved.
Good luck with your project.
 

Users who are viewing this thread

Top Bottom