lock controls all in one go

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi

I have a form that I want to use for date enquiry as well as data entry.

When the user just wants to enquire I want to be able to lock all the
controls so that no changes can be made.

How can I do this?

There must be an easier way than a line of code for each control
 
Take a look at the form's Data properties:

You could set the AllowEdits, AllowAdditions, and AllowDeletions properties
to false:

Me.AllowEdits = false 'etc.

Or, you could change the RecordSet Type to Snapshot.
 
Back
Top