[AccessD] Query/Forms Update Data

There are a few situations where you end up with a non-updatable query.

You can quickly tell if your query is non-updatable by clicking on the 
run  (!)
and checking the navigation buttons on the bottom.  If the new record  (*)
is grayed out, then the query is non-updatable.

A list of causes for read only queries are:
http://www.allenbrowne.com/ser-61.html

If still stuck, post your SQL back here

Calvo, Denis wrote:

>accessd at databaseadvisors.com
>
>Using Access 2002.  Our Forms (based on a query) in general allows for
>data entry.  However when I add another specific table and its link to
>the main source of the query (another table) the query/form prohibits
>produces results but does not allow for data entry/update?  How do i
>determine what is causing this?  i could remove the linked table from
>the query and the resultant form now allows for updating/data entry once
>again.  I have tried to "look" at all the characteristics of the problem
>table but find nothing that tells me it would preclude the form's
>abitlity to update records.   
>
>Denis Calvo
>Denis.Calvo at dgs.ca.gov
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada