Help! Can't add/edit data in a form created from a query.

[Guest]

I have created a form based on a query, and it won't let me add or edit data
in any of the records. I have checked the Properties at the form level and
field level and none of the records/fields are locked.

I'm using an Access 2003 Design Master. The query using the DISTINCT
parameter and requires Users to input a parameter before it will run. Is that
causing the problem? I have other forms based on the underlying tables, and I
haven't had any problems updating the records with those forms.

 

[Guest]

By using the DISTINCT operator, the UniqueValues of the proerty becomes true.

This makes the recordset not updateable.

For a bit information on updateable recordsets here's a link

http://msdn.microsoft.com/library/d...l/acconDeterminingWhenCanUpdateDataQueryS.asp

 

[Guest]

Thanks for that information. I think I've resolved my problem by using
DISTINCTROW instead of DISTINCT.