Lock drop down value if checkbox is NOT checked

[rplohocky]

Hello,
I wrote this code but doesn't seem to work. I have a combobox (Combo565) that has a drop down list. I also have a check box (LetterRecieved) on a form. I am trying to lock down the combo box when value "3. Oracle Order Sent" and the check box is NOT checked. Once the user receives the letter they would check the check box and the combo box would unlock and allow the user to continue with the next steps.
Here's what I have so far. Any thoughts?

If Me.Combo565 = "3. Oracle Order Sent" And Me.LetterRecieved = False Then
Me.Combo565.Locked = True
Else
Me.Combo565.Locked = False
End If

 

[james_lankford]

where do you have taht code

 

[stumac]

to lock it - you will need to add the code to the forms oncurrent event as well as the afterupdate event of the 2 controls. Otherwise there is times it should be locked when it isn't and vice versa.

I find a good alternative is to use conditional formatting to disable the control based on an expression.

Eg: [Combo565]="3. Oracle Order Sent" And [LetterReceived]=False

On conditional formatting edit rule screen there is an option to disable the control to the right of the format options.