recordset not updatable on my forms

[aussie_user]

HI,

Wondering if anyone can suggest what I am doing wrong. I recently added some subforms with one to many links to a tabbed form that I have.

Since adding the subforms the rest of the form will not let me update any fields. The subforms are working fine, but the main part of the form will not work. Whenever I try and entre data into a field I get "This recordset is not updatable" in the lower left hand corner.

I've tried copying my query and altering it, as I think the problem may be related to the joins.

Any ideas or suggestions would be appreciated.

Thanks

 

[keith_pyrasoft]

Hi

Is it possible your mods have provided you with non-updateable queries?

Have you tried setting Form / Data / Recordset Type to: Dynaset (Inconsistent Updates)?

Though be careful that's really what you want....

Regards

Keith

 

[Kevin_S]

Keith is on the right track - search in help for "cant update query" and you will find your answer under the heading "When can I update data from a query"

HTH,
kevin

 

[Pat Hartman]

Sounds like you modified your mainform query when you added the subforms. Are you sure that was necessary? What change did you make?

 

[aussie_user]

modified query

I modified my query by adding

DateReportDue (from Reports)
Date Report Recd (from Reports)

PmtDue (from Payments)
PmtActual (from Payments)
GST (from Payments)

for the last 3 fields under total I selected SUM so that in various other reports that are tied to this query I would only get the sum of the payments rather than the project showing up 5 times if there happened to be 5 payments for it.

Both the Reports and Payments tables are in a one-to-many relationship with the Project table. They are linked by ProjectID

 

[Calvin]

In your subform properties check that your Link Child and Link Master properties are correctly labled, also make sure that ALL tables in your query have their Primary Key/Unique ID fields in the query as well not just the primary table.

 

[Pat Hartman]

Your mainform query should NOT contain the tables that are used to populate the subforms. That is what is making the query non-updateable. You have two separate 1-to-many relationships where the many-side tables have no relationship to each other. You cannot make a query from this set of tables that will make sense, let alone be updateable.

 

[Calvin]

Pat Hartman, good catch.

 

[aussie_user]

Thanks

Thanks Pat,

Now that I understand that point I can fix the problem.