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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Thanks for that information. I think I've resolved my problem by using
DISTINCTROW instead of DISTINCT.
 
Back
Top