editing data in a query

  • Thread starter Thread starter Mike J
  • Start date Start date
M

Mike J

I have a query using three tables linked by an index...
etc.

I then have a form that uses the query. I was able to edit
any data on the form but now I cannot. I added a combo
box but that's it. I can't even edit any data in the query
(datasheet view). What did I do wrong now?
 
Chances are that you changed the query in some way that has made it
nonupdatable.

See these MS Knowledge Base articles for more info:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc
 
Back
Top