DSUM Problem totaling value of a query to a control

[Surdeymon]

Hello - I have a form (frmIssueList) with a subform (frmIssueChgList). Each IssueID has a one to many relationship with the subform. So when an Issue is create a list of charges that fall under that issue is inserted into a subform. That is ok with the RunSQL command. The only problem is that I want the total value of the InsPrePay field set into a control names TxtInsPrepay on the main form. I created a query called qry_PreChargeIssueTotals - I get an Object Required Error that I cannot figure out. Can you deteermine what is wrong with my DSUM command? Thx in advance and let me know if you have any questions. Thanks! Rob

---------------

DoCmd.RunSQL ("INSERT INTO dbo_IssueChgList_t ( IssueID, Acctno, Chgno, ChgPayAmtPrePay, InsPrePay ) SELECT forms!frmIssueList!TxtissueID AS IssueID, qryContractVariance.AcctNo, qryContractVariance.ChargeNo, qryContractVariance.ChgPayAmt, qryContractVariance.PayAmt FROM qryContractVariance")

Dim curX As Currency
curX = DSum("[InsPrePay]", "qry_PreChargeIssueTotals")
Set [Forms]![frmIssueList]![TxtPreInsPay] = curX