I cant enter data in a query in access?

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

Guest

I had this problem before but cant remember how to fix it. i created a new
Query and form in my database and i am unable to add data to the form or the
query, I can however add to the main query that the information is drawing
off.
 
Brian,

There are many reasons why a query can be "Non-Updateable". A Google search
will list several. The chances of it occurring increase with the number of
tables and joins. My general strategy is to simplify the query until it can
be updated, and show fields from additional tables by using the Column
property of combo boxes.

Hope that helps.
Sprinks
 
Back
Top