Not able to update a form

[luv4nrt]

Hello all,

I have a form that gets its data from a query that is inner joined with
3 tables. I am not able to edit the form. I have a similar form that
gets data from the same query and I can edit that form. I have tried
to check the properties on both forms and can not determine the
difference. Please help!

 

[Ken Snell \(MVP\)]

See these articles for information about what can make a query nonupdatable
(watch for line-wrapping):

When can I update data from a query?
http://msdn.microsoft.com/library/d...l/acconDeterminingWhenCanUpdateDataQueryS.asp

Harnessing the Power of Updatable Queries
http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_harness.asp

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

 

[luv4nrt]

Thank you Ken. Perhaps in the future I will make better use of
Microsoft's support sites.

 

[luv4nrt]

Thank you Ken. I was able to figure it out. Two of the tables were not
linked by their primary keys. Perhaps in the future I will make better
use of Microsoft's support sites.