Can't update a field in a parameter query?

[jaaret]

I have a query based on a single table. If I open it up with no criteria I can (of course) update the data. However, if I add criteria based on form parameters I can no longer edit the data after the query runs. I'm not finding a reference to this on the Microsoft site. Is it not possible to edit data in a parameter query?

 

[PHV]

What is the SQL code of your non-updatable query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886