How do I lock/unlock fields in a form?

G

Guest

I have a database with multiple forms that users are able to get into using a
main menu with a drawdown option...most of the fields on the forms are
"locked" so that I am not able to enter any data. Any idea how to "unlock"
all or some of the fields?
 
B

BruceM

Are they bound controls (that is, is their Control Source a field from the
form's Record Source? If not, there may not be a reason to unlock the
control.

Having said that, the form's property sheet has a place on the data tab to
set the Locked property. To open the property sheet, open the form in
design view, click the text box or other control to select it, and click
View > Properties. They may also be locked using code, maybe in the form's
Current event.
 

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

Top