@ebasshead
You cannot edit/modify records on a form that is based on a summary query.
So what you do is just create your form based on the first query.
To do this the easiest way is to drag and drop your first query into a new form. Give the names. Now you can calculate the totals on the sub form instead of the query.
Go to design mode of the sub form, in the form footer section, insert a text box and put this
- =SUM([your field name goes here!])
This will calculate the totals within the sub form . If you need to calcualte totals for every field then create more text boxes and insert the code above for each text box.
But you cannot view the totals field you just created in the footer. So In your main form just reference the text box in sub form’s footer . To reference use this syntax.
Create a text box in the main form. And type:
- =Forms![name of main form]![Name of subform]![Name of Subform footer text box]
Now you can view the total in the parent/main form and at the same time modify records..
Hope this helps..
If this method does not work then give me the details of your object descriptions: ie what is your first query doing and what is that you expect your form to dispaly and what you are really trying to achieve with respect to the query + forms.
Thankyou
Jerry
37
