Cannot add new record with query

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a query with 3 tables joint together. I cannot add any new record
(The new record button is not enabled). However, it allow me to add new
record if the query only have 2 tables. Do I missing something?

Thanks
Chris
 
Chris said:
I have a query with 3 tables joint together. I cannot add any new
record (The new record button is not enabled). However, it allow me
to add new record if the query only have 2 tables. Do I missing
something?

See the help file topic, "When can I update data from a query?"
 
Hi Chris,

adding the third table is making the resulting
recordset 'non-updateable'

for some rules about creating updatable queries search
Access help for 'updatable' (without the quotes).

hth

chas
 
Hi Chris,

this can sometimes occur with multiple tables in a query.
Search Access help for 'updatable' (without the quotes)
for a discussion of the circumstances.

hth

chas
 
Back
Top