Lock Value in Combo Box if Non-Blank

[ErikAE]

I have two cascading combo boxes; one filters data for the next - nothing special.

The first combo box – after performing a DLookUp in the ‘On Change’ event – will determine a value for the second combo box. If it determines a BLANK value, I want the user to change the value to anything provided in the drop-down in the second combo box. This works fine.



But what I want to do is lock the value in the second combo box if the first combo box determines a NON-BLANK value; i.e. I don’t want the users to be able to change the second combo box if it is NOT BLANK. I don’t know how to do this.

Regards.

[June7]

Maybe set the combobox Locked or Enabled property?

[ErikAE]

I attempted that, however the lock prevents the combo box from being updated; i.e. no value.

[June7]

You set the value of the combobox then set the Locked property? The code works for me.

[ErikAE]

Ah, you mean use code; I thought you were referring to the 'Locked' property.

Okay, let me rustle up some code, & I'll see how I go.

Thanks.