Entries in a datasheet subform updating the main form

[Allie]

Hi All,

I have two forms both feeding from 2 different tables.
The main form is a summary of the sub form, which is a
datasheet. For example, on a given date a person can have
up to 50 entries in the sub form and these entries must be
summarized on the main form.

Main form: total transactions, total minutes used, total
issues, total declines

sub form: as an entry is made here it adds 1 to the total
transactions; add how many minutes it took to perform the
transaction to total minutes used (each transaction has X
number of minutes);then if the transaction was a decline
it would add 1 to the total number of declines.

I am trying to use a recordset on the subform to tie the
information back to the main form but I am not getting it
to work.

Please help

Thanks

 

[Ted Allen]

Hi Allie,

Usually I would do this in the reverse. I would make the
main form a continuous form with the data, and then put
the summary/calculated info in the footer.

But, You could also do what you want to do by using
Domain Aggregate functions to calculate the values in the
main form (DSum(), DLookup(), DCount() ). Or, you could
base the main form on a summary query that groups by
UserID or whater the case is. But, in that case you may
have to have a button or event requery the main form when
new records are added.

Those are a few things off the top of my head. I'm sure
others may post other ideas as well.

HTH

-Ted Allen