edit field data in query

[Selby]

Access 2003
I need to be able to enter information into a table only for those fields
shown in a select query. I have tried adding the table to the query but it
will not enter any information or allow any changes to the existing
information.

In other words, I have a blank field on a query that I am trying to enter
data in and have this new data update to a different table than the one the
query is currently populating from. How can I do this?

 

[vanderghast]

*If* the actual query is itself updateable, SAVE it. Make A NEW QUERY, bring
your saved query and your table, add the join between both to associate both
(which record in your table 'maches' each record in the query), and bring
the fields from your table in the grid. May need to be sure the primary key
of the table is also in the fields you brought to the grid. If the join you
made between your table and your saved query is acceptable, this new query
should ALSO be updateable.

*If not*, make a table out of it, and proceed like previously, using that
temp table rather than the not-updateable saved query.


Vanderghast, Access MVP