access problem

[nshack31]

here is a screenshot of my subform in access...

the problem is that i want to code it so that if a user selects a policy, the policy combo box (cboPartno) becomes not enabled.

ive tried the following...

Private Sub cboPartNo_Click()
If Not IsNull(Me![cboPartNo]) Then
Me![cboPartNo].Enabled = False
End If
End Sub

any ideas?
thanks

[edited by: jatar_k at 11:48 pm (utc) on Jan. 8, 2008]
[edit reason] no urls thanks [/edit]