2nd Query Prevent Data Entry

[ozsupra]

I have a query based on two other queries

If I create a form based on the fields in my query the form will not allow me to edit any fields - no matter what.

All fields are unique however I am stumped as to why I can't edit the data. Even adding in the second query immediately stops data entry even without linking.

Any suggestions as to where to look would be appreciated. :banghead:
A.

 

[namliam]

is your second query using any form of distinct / group by / pivot / etc?

This will make any resulting recordset to be uneditable

 

[ozsupra]

is your second query using any form of distinct / group by / pivot / etc?

This will make any resulting recordset to be uneditable

It's doing a number of sorts and has a single filter that's all.

 

[namliam]

There must be some reason why it is uneditable.

group by
lack of keys
pivot
distincts
cartesian product

 

[ozsupra]

It's probably staring me right in the face - but I can't see it.
Please find attached the little buggers.
Thanks in advance.