can't change data in a form

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

Guest

I have a form based on a query. Uses continuous forms for the view. However
I cannot edit/change any of the data. Neither can I change anything in the
underlying query (which should tell me something, but I don't know what!).
What should my settings be to allow me to change data?

Thanks in advance.

Jerry
 
You haven't shared anything about your query other than the records can't be
edited. If you look at all your join lines, are the fields on one side of
the join always a primary key? Are you using any GROUP BY or totals?

May you should share the SQL view of your query and identify which fields
are primary and foreign keys.

Duane Hookom
MS Access MVP
 
My last post seemed to have posted a blank message. anyway, I figured it
out..it was faulty relationships. It's working now.
Jerry
 
Back
Top