table update from form attached to query

  • Thread starter Thread starter jane
  • Start date Start date
J

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.
 
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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top