Lock datasheet rows for values

[phil]

Using the On Current event of a datasheet I can lock controls within a
datasheet based on values of controls within the row however I've encountered
two problems: (a) each time I click on a row the Got Focus event fires and I
get an error that I can't change a control that has the focus, (b) all rows
of the datasheet are either locked or unlocked depending upon the value in
the selected row. The second issue's not a show stopper bu the first one is.

Is there an alternative event like On Row Bound that I can use?

 

[phil]

No worries, solved it. Use the Locked property instead of the Enabled property.