Enter Data using a query

[RC-]

I have several queries, some of them allow me to enter data after running
the query and others do not offer the opportunity to enter data. What am I
missing, how can I make all my queries allow me to enter data into them?

Sorry for the vagueness of my post, but I simply don't know of a better way
to explain what's happening.

Thanks,
RC-

 

[John Vinson]

I have several queries, some of them allow me to enter data after running
the query and others do not offer the opportunity to enter data. What am I
missing, how can I make all my queries allow me to enter data into them?

Sorry for the vagueness of my post, but I simply don't know of a better way
to explain what's happening.

Thanks,
RC-

See "Updateable" in the online help.

Not all queries are updateable, and it's NEVER necessary for a query
to be updateable in order to update a table: there's always another
way around the problem. For one thing, you should *never* be opening a
query datasheet and trying to edit it!! Use a Form (perhaps with
Subforms if you have multiple tables).


John W. Vinson[MVP]

 

[Van T. Dinh]

Queries that use 2 or more Tables may or may not be updatable depending on
the links / joins between them in the Query.

Check Access Help on "Updatable Queries" which explains more and shows some
techniques to convert non-updatable Queries to updatable ...