form based on query - cant edit records

[tweety]

i have a form that has its data based on a query, all it shows is customer who have not paid using a check box. the idea was to to be able to check the box so the customer order can be paid, but the check box cant be ticked!!!



this is the cause (having the totals on will make the query read only) http://allenbrowne.com/ser-61.html

But what is the fix????
thanks

[JoeM]

You cannot edit Aggreagte (Totals) query. Think about it. Aggregate queries usually combine/collapse multiple records down to a single record. So if you try to edit a row from an Aggregate Query, how would it know which record in your underlying table to edit with that row in your query could represent multiple records?

In order to figure out a way to do this, I think we are going to have to know more about your data structure.
What is your table structure?
Why are you aggregating records?

[scoobz1234]

I had a similar issue with my Form that was based of a query, if you go into the properties of the form and set the RecordSet Type to "Dynaset (inconsistent updates)" and then do the same for your query, this should fix your issue.

[tweety]

i have attached a copy of the the table structure,

and a copy of the query,


the reason the records are grouped is a purchase order is made up of many items, hence they are grouped. if i dont the form will will have 100's of boxes to tick when a customer hasnt paid for an order

[tweety]

Thanks i just tried that, changing the form and query to Dynaset (inconsistent updates) but still no luck :-(

[scoobz1234]

any way you can upload your db?

[JoeM]

I had a similar issue with my Form that was based of a query, if you go into the properties of the form and set the RecordSet Type to "Dynaset (inconsistent updates)" and then do the same for your query, this should fix your issue.

Was your query an Aggregate Query?
I am betting it may not have been. I don't think that making the change your mentioned will suddenly make a non-editable query like an Aggregate Query editable.

tweety,
Instead of doing it with Aggregate Queries to combine all the records in a single purchase order, have you tried using SubForms? Your main Form would be the high-level Order information, and the SubForm would contain the individual records which make it up.

[tweety]

Db attached