table update from form attached to query

[jane]

In the older versions of Access 95, 97 a query could be a
form's source of input. When a field was changed the
field in the data base was updated. In Access 2000, I
have a form tied to a query. I can view the information
but can not update anything on the form. Every field is
locked even though the lock feature is set to "no". What
property field is causing everything to be locked.

 

[John Vinson]

In the older versions of Access 95, 97 a query could be a
form's source of input. When a field was changed the
field in the data base was updated.

This is still true.

In Access 2000, I
have a form tied to a query. I can view the information
but can not update anything on the form. Every field is
locked even though the lock feature is set to "no". What
property field is causing everything to be locked.

A200x is more stringent than A97 about the exact SQL syntax: some
queries which were updateable in A97 should not have been and are
blocked from updating. If you'ld care to post the SQL view of the
query, someone might be able to spot the problem.