Cannot make entries?

[QB]

I have a form which worked perfectly.

All of a sudden I can no longer make any new entries. I have obviously made
a chage but have no clue what I have done.

The form properties are set to dynaset, edited records. What is baffling
me more is if I open the recordsource in query view and run the query results
I cannot change the data there either?

The underlying sql is below for reference

SELECT tbl_Ing.*
FROM tbl_Ing INNER JOIN [tbl_Planif] ON tbl_Ing.PlanifIngId =
[tbl_Planif].PlanifIngId
ORDER BY [tbl_Planif].NoProjet DESC , tbl_Ing.Type;

Anyone have some ideas?

Thank you,

QB

 

[Allen Browne]

The query should be updatable if there is a unique index on the foreign key
field. There will be if you have a relationship with referential integrty
enforced.

Occassionally, Access will remove the relationship and index when you
perform a compact/repair if it discovers bad (non-unique) data in the field.

If that's not the issue, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html