code for enable/disable buttons on form based on data in table

N

newtoaccessdb

I am very new to code, and need to make a form uneditable to users who
are not the author of the record, as well as make uneditable to anyone
once a "completed" button is pushed which sets the date into a table.
Any help would be greatly appreciated.
 
D

Duane Hookom

You would need to run some code triggered by the On Current of the form and
possibly the After Update of some controls. This code would set the
AllowEdits property of the form to True or False based on values in your
un-named text boxes or fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code to enable/disable buttons on form based on info in table 3
Code to enabld/disable buttons in form based on information in table 1
Enable/Disable a field based value of another field in the same table 9
Hiding a button based on a value in a table 1
Access MS Access 2007 Form stuck in Read Only View 1
Disable fields in a form on open & enable with button click data e 2
Tabbed Control Form 2
Some forms based on queries are uneditable, but queries don't overlap 1

Top