Full Version: "Update" form not updating anymore?!
UtterAccess Forums > Microsoft® Access > Access Forms
JackLamberton
For some reason, my "update" form now no longer allows me to edit a recordset (add, change or delete records). The "add record" on the record selector bar is dimmed. I must have disabled something in the form's property inadverently??? It used to work fine until just now.
Any idea why?
Thanks.
Jack
Bob_L
Check the AllowAdditions and AllowEdits properties. Also, you may have made a change to the underlying query which rendered it nonupdateable.
See here for more info:
http://allenbrowne.com/ser-61.html
JackLamberton
Bob,
ure enough, I made a change to the underlying query that threw me off. After correcting that, I can now update! Thank you very much for your prompt, concise and on-target solution. Also your link to Allen Brown's list is helpful.
Thank you again!
Jack
Bob_L
Glad we could help thumbup.gif
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.