Continuous form subform wont update w/out main form refresh 1

[EmployedAgain]

I am working on a medical research DB with many Q and A surveys. One of them is large so I am using a tab control with subforms to hold each section of questions (questions pulled from a question table and score saved into an answer table). The last tab is the totals (answer scores). The totals tab contains a subform based on a query that groups the questions by section and adds up the scores from the answer table plus a grand total and displays them in a continuous form.

I have tried every event seemingly and I cannot get the totals to update if you change a score on one of the tabbed subforms (except the first one for some odd reason - also the first total displayed in the continuous form). The only way I have found to force the scores to be updated on the totals tab is to click a refresh button on the form header of the main form (where the patient and visit info is selected). I dont want the user to have to do that. I have also tried it on one of the Q and A forms that's just subforms w/o a tab control, same thing. I've tried refresh and requery on current, got focus and change events for the most part. Am I missing something obvious or is there a better way to do this?

 

[PHV]

Have you tried a Recalc too ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[EmployedAgain]

I've been fighting with this form so long and thats all it was! Thank you! It seems to be working now. I did a recalc of the totals subform on the afterupdate event of a few of the option groups and so far so good. Some of the option groups are also continuous forms so its running on each answer selection and showing the hourglass briefly but thats more tolerable than having to click a button.

This is a great forum!

TIA
B