lock controls all in one go

[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

 

[Cheryl Fischer]

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.