Query not updating anymore?

[bar891]

I have a form with two subforms. the second subform used to update whenever i changed a value in subform one. Now it doesn't, even when i tell it to requery. I have to close & reopen for it to change. I have been on this for two days now & require help please.

test.zip

[June7]

I have never worked with an accdc file. You provided the frontend but no backend. The issue is form data refresh. Can't test without data.

[bar891]

Sorry..... new to this. Try Now

[June7]

I presume the form of issue is Expense Report Detail.

Subform2 (Total Reports Subform) cannot refresh until data entry/edit of subform1 (Expense Reports Subform) is committed to table. Commitment happens when form closes, move to another record, or run code. As is, the only way you would see subform2 refresh is when moving to another record in subform1. That does work. Need code in subform1 event to commit data. This would likely have to be in the AfterUpdate events of Category and Cost fields.
DoCmd.RunCommand acCmdSaveRecord

Why even have the Total Reports Subform? Those calcs can be done directly on the main form. Just include all the Expense Reports fields in Query1 and use that query for the form's RecordSource. Change names of the calculated fields that have names conflicting with fields in table and adjust formulas. Do the Product Total calc in textbox instead of query, could actually do all the calcs in textboxes.
SELECT [Expense Reports].*, [Total Quote]/11 AS ExpGST, [Total Quote]*0.3 AS ExpManagementFees FROM [Expense Reports];

BTW, advise no spaces or special characters/punctuation (underscore is exception) in names.

[bar891]

I don't understand... On my system, Subform2 doesn't update when moving to another record in subform1. I can have a whole table records & subform2 stays on the same record. the only way it changes if i move to another record & return.

[June7]

I am running your db on Windows 7 and Office 2010 but I expect would get same behavior on Windows XP Office 2007. Subform2 calcs refresh when subform1 moves to another record. If this does not happen for you, can only think the form is corrupted.

However, subform2 is entirely unnecessary as already noted although the same situation will apply. Run code to commit subform1 record.

[bar891]

Thanks for your help. I have removed subform2 & have done calcs in textboxes & works....
Many Thanks