On Fri, 22 Jul 2005 12:12:01 -0700, "titan"
Some queries are updateable; some are not. Try opening the Query in
datasheet view - is there a "new record" line? If not, check the table
definitions: do you have a unique Index (such as a Primary Key) on the
field in the "one" side table that you're using for the join? That's
essential, and a common cause of this problem. If that's not it,
please open the Query in SQL view and post the SQL text here.
Then you MUST - NO OPTION - use an Unbound form. A Query is not a
separate reality from its table; editing the query edits the table,
the query is just a view of the table.
Use a different form, a Form with nothing in its Recordsource
property, to collect your criteria.
John W. Vinson[MVP]