Enabled/Locked Property Settings

[kermit5]

I have a form (described in a previous posting on 4/4) whereby the user defines a series of hinges that will be used for a specific project. Each hinge has several properties including a mfr, a series, a height, a finish and some of the hinges have a width.
I have a product price list that has each of these properties in separate fields.

I want my form to do the following:
When a hinge series is chosen that does not have a specified width value, that is ProductWidth = Null (in a numeric field)I want the cmbHingeWidth.enabled = False. Is there a way to only disable this box for the current record and not previous or future records (unless the above condition is met?)

If so, how do I accomplish this? Another option may be to change the Locked Property to True if ProductWidth= Null if this will accomplish a similar end result.

 

[buckfast]

in the form current event

if isNull(product.width) then
controlName.enabled = false
end if

putting this in form current means that the test will be perform when you change records

cheers,
Ewen