Hi All,

Have been trying for a few days to get this going, but after several handfuls of hair i am still stuck.
I have a form which is based on a query, the query data is as follows. Field 1) contains import numbers and are Grouped by these numbers. Field 2) Contains a SumOfAmount for the $ value for the grouped import numbers. So data from the query looks like
Field1 SumOfAmount
12405 $32000
14567 $23000 and so on

On my form i have the field1 and sumOfAmount displayed, this form contains a subform which has the detail records for the query the main form is based on. So as the user selects a record in field1 the subfrm changes to display the details of each line that the (SumOfAmount) displays.

Now my problem. I require the end user to be able to edit data ($ Value) in the subform, this works ok, but the SumOfAmount does not recalc - refresh - requery regardless of what code i run on after update from the data entry field, or any other event i run. Does anyone know how i can refresh this (SumOfAmount) in real time, without having to close and reopen the form?

Thanks in Advance

Darren

Did you try to refresh it by using the On Current Event of the subform?

The value of Field1 you are selecting, is it in a combo box, or a list box? If not, what control are you using to select the value (text box with action button for exemple)?

You need to go to the subform's properties, and then on the Before Update event of the sub form, you need to requery the control with the SumOfAmount data.

Did that help?


mmcdonal