editable form

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

Guest

I have to filter the table and have the user edit only
those records. I created a query to filter the recors.
But, when I use the query to create a form, it is
uneditable!!!? What do I do?

Thanks
 
I have to filter the table and have the user edit only
those records. I created a query to filter the recors.
But, when I use the query to create a form, it is
uneditable!!!? What do I do?

Thanks
Click to expand...

Try setting the form's RecordsetType property to "Dynaset (Inconsistent
Updates)". If that doesn't work, post some more information about the
query/tables.
 
The recordsettype Property is set to Dynaset!! I could
have sworn it worked yesterday!!! The query is using only
one table filtered on a field "rate" is null. It lists
all the employees who do not have a rate. The user needs
to update the records with this info. I have set the form
to allow edits and 2 field in the form, ID and name are
loacked and the rate field should be editable?

What other info do you need?

Thanks
 
I solved the mystery!! The query was using DISTINCT rows
and that was making the form uneditable. Thanks for your
help.
 
Back
Top