Hi,

I'm very new to Access (Self taught trial and error method!) and would appreciate any help with a problem I'm stuck on. I'm using Access 2000 and have a simple database with approx 30 fields.
I've got a command button that when clicked starts a macro (setvalue) What I'm trying to achive is that when the button is clicked it locks one of my fields (I may want to lock all the fields but hey one step at a time!) so that it cant be editted or in other words, makes that field in that record 'read only' I'm guessing that I'm messing up with the expression builder. I've tried looking up the definitions of the various operator buttons as I think (but don't know) this is where I may be going wrong. In expression builder I select the form I'm using then the field that I want to attach the value (locked) but it doesnt work.

Any ideas please :)

In VBA code:

Me.ControlName.Locked = True

In VBA code:

Me.ControlName.Locked = True

Thanks Paul,

will this just lock the specified field in the one record or will that lock that field in all records?


Chris

It will stay locked as you navigate through records. If you want to unlock it when you change records, put code in the current event of the form.

EXTREMELY helpful!

Your code was exactly what I was looking for! And so simple!

Thank you VERY much!