field locks in forms 1

[mac5]

Can anyone tell me if I can lock or unlock a field within a form based on data a user enters on the form?

Also I have an application that uses a current year different from the calendar year. Can I code a value in access that tells what the application year is?

Thanks,
Bill

 

[BanditWk]

One can unlock/lock a field to prevent modification or whatnot by using:

Me.FieldToLock.Enable = False
Me.FieldToLock.Locked = True

This allows the field to look like all the other fields, but prevents TabStop and anyone from clicking in it to modify it.

However, just set the Enable to False if you're wanting to gray out the field in normal processing.

Not sure on your year question. Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)