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's data from the one side table and one project's data 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.

 

[jdraw]

Can you post a copy of you database - at least enough to show the issue (remove anything confidential)?

 

[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.