Hi,
I have a query which when run I would like the user to be able to change the values to alter the values in the table however the data from the query seems to be locked despite the query being opened in acEdit mode.
It is a query based on a query based on a query based on a table. Is this the reason why I can't make any changes? And if this is the case, can I get around the problem somehow? I'm not sure I can get to the end query in just 1 step as there is a lot of manipulation of data on the way to the end result though some fields aren't changed all the way through. I have tried taking the unchanged fields direct from the original data table in my final query but this still prevents those fields from being changed.
Is there any way I can make the fields editable without doing the manipulation in just 1 step?
Thanks in advance
John
I have a query which when run I would like the user to be able to change the values to alter the values in the table however the data from the query seems to be locked despite the query being opened in acEdit mode.
It is a query based on a query based on a query based on a table. Is this the reason why I can't make any changes? And if this is the case, can I get around the problem somehow? I'm not sure I can get to the end query in just 1 step as there is a lot of manipulation of data on the way to the end result though some fields aren't changed all the way through. I have tried taking the unchanged fields direct from the original data table in my final query but this still prevents those fields from being changed.
Is there any way I can make the fields editable without doing the manipulation in just 1 step?
Thanks in advance
John
