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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference in size of actual access database and its backup 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Need help in making asset history in my current database. 1
Access can't see data in forms and queries 1
Access Access Report Works on One Machine but not Another 3
Make a change in Access DB backend 2
Can't create a report from my query in Access 1
Access Query problem 1

Back
Top