Lock Combo box after focus on subform

[flavioso]

Hello. I have a main form which has a list of vendors in a combo box. Once the user selects the vendor, and starts keying in order information in the subform, I want the combo box to be locked.

I have tried using the On Got Focus with the following code, but unable to do so. The subform name is frmSUBDOCKET. the combo box is called cboVENDOR and is located on the main form called frmDOCKET.

cboVENDOR has this code attached to it in afterUpdate:

Private Sub fldVENDORID_AfterUpdate()
Me!frmDETAILS.Form!cboPN.Requery
End Sub

frmSUBDOCKET on Got Focus Code:

Private Sub Form_GotFocus()
Me.frmDOCKET!fldVENDORID.Locked = False
End Sub

The problem is that the combo box doesn't lock. Does anyone have any suggestions?


Thanks in advance,

Brad

 

[pbaldy]

For starters, to lock it would be True, not False. Second, if that code is in the subform, you'd need to reference the main form, not Me. Third, you need to refer to the combo, not the field. Try:

Forms!frmDOCKET.cboVENDOR.Locked = True