My Form is Locking Me Out

M

MO

I have a form that is connected to a query. For some reason when I added
another table to the query and connected the two tables, the query and form
that is connected to it lock up so I cannot add or delete any information.
When I go back into the query and delete the table, the query and form work
except that now I cannot use the info from the other table that I had to
delete. Any thoughts?
 
S

Steve Schapel

Mo,

The inclusion of the additional table into your query is apparently
rendering the query non-updateable. There are a number of conditions
that define whether a query is updateable or not - there is some good
information in Access Help about this. If you need more explicit help
with this, maybe you could post back with the SQL of the query.
 
Top