main form to sub form to another sub form

[jn]

have a remittance module that is written via access 97

the main form gives an account number, and a patient's name

the main form links to the first sub form by account number. this sub form has visit date, remit date, charges, payment
etc

sub form 1 links to sub form 2 by the visit date. this form shows the detail transactions tha
make up the summary for a given date in sub form 1

i want to sum the payments, ins co payments, etc in sub form 2 and display the totals in sub form 1

i have been using dsum to do this. i have gotten dsum to tally the individual totals for an account bu
i can not get the linkage to work in dsum, so that dsum knows i only want totals for a specific visit
date. every concept i try, get an error
=DSum("[payment]","[qry visit remittance detail]","[qry visit remittance detail]![dateid] = [forms]![remittancesubcopy]![remittance sub detail]![dateid]"

if i go as far as the first qry visit remittance detail, i get a total. if i continue i get an error
dateid is how sub form 2 and 1 are linked. remittancesubcopy and remittance sub detail are the form name
of the 2 sub forms

so what is causing to err

thank