Recordset Not updateable in Form

[msreed]

I needed to change an existing sub-form that was updateable b/c the wrong fields were selected. Since then I can't update my record. The SQL code I used is:

Forms![frmHUBPayments]![frmBILLSDuesub_OLD].Form.RecordSource = "SELECT tblBillHeaders.HeaderID, tblBillHeaders.ClientID, tblBillHeaders.BillNo, IIf(IsNull([TotPaid]),0,[TotPaid]) AS TotalPaid, tblBillHeaders.InvoiceNo, tblBillHeaders.BillDate, tblBILLActivity.TotalFees, tblClients.ClientNo, tblClients.ClientName, [totalfees]-IIf(IsNull([TotPaid]),0,[TotPaid]) AS Diff, tblBillHeaders.Pay, tblBillHeaders.ClaimID, tblClaims.ClaimNo, tblClaims.ClaimSSN, tblClaims.ClaimFull FROM (((tblBillHeaders INNER JOIN tblBILLActivity ON tblBillHeaders.HeaderID = tblBILLActivity.HeaderID) LEFT JOIN qryPAID ON tblBillHeaders.HeaderID = qryPAID.HeaderID) INNER JOIN tblClients ON tblBillHeaders.ClientID = tblClients.ClientID) INNER JOIN tblClaims ON (tblBillHeaders.ClientID = tblClaims.ClientID) AND (tblBillHeaders.ClaimID = tblClaims.ClaimID)WHERE (([totalfees]-IIf(IsNull([TotPaid]),0,[TotPaid]))>0) AND " & strFILTER

I'm not grouping and my recordset type is set to Dynaset Inconsistent Updates, any suggestions?
Thanks, Missy

 

[skittle123]

this error usuly pops up if the recordset you are selecting is not unique, check your primary keys on all the tables you are joining,

 

[msreed]

No, my tables are fine. The query that is linked is the change. Maybe its that query? All of my joins are inner, with the exception of that query. But those are the fields I need. I'm still playing

 

[Rolliee]

This recordset is so complex that ACCESS does not have enough information to do all that you ask. You would be better off adding the info to the proper table and then doing a requery of the control.

Joins are frequently like that.

rollie@bwsys.net

 

[strantheman]

Hi Missy

Im dealing with a similar problem, I think.

Are you getting some sort of "not updateable" error? Are you using a split database or linked tables?