Query is updateable, form is not

[rpochoda]

I have a form where the data source is a SQL query set dynamically in VBA based on entries in two unbound combo boxes. The query is a one-to-many join that selects one client from the one side table and one project from the many side table. If I copy the resulting query from the record source line in the form properties to a SQL query screen, the query results are updateable (even the one side, which surprised me). But the same data in the form, even those fields from the many side, is not. What am I missing? This is a standalone database, no networking, sharing, privileges, etc.

[June7]

Should use a form/subform arrangement for data entry/edit. If you want to provide db for analysis, follow instructions at bottom of my post.

[rpochoda]

Thanks for your reply. The error has been found. There was a vestigial DISTINCT in the VBA version of the query which I didn't catch because I was only looking at the query in the form data source properties.