Need to stop update on drop-down. Need to keep OldValue

[LindaRuble]

Hello,



I would like to stop the user from changing informaiton on a record by mistake. I do not want the user to change the value of the drop-down after a value has been already input.
I have successfully written VBA to pop up a message only when someone changes the drop-down value and not when the value is Null.

What I need help with is to keep the old value of the drop-down, or at least not update a new value. Here is the code I have tried but can't prevent a new value from being saved on top of the old value.


I've tried....

Private Sub Combo75_Dirty(Cancel As Integer)
    If Not IsNull(Me!Client_Division) Then
        Me.Client_Division.Value = Me.Client_Division.OldValue        
        MsgBox "A CLIENT/DIV has already been selected. Please do not change."
    End If
End Sub

I've tried....

Private Sub Combo75_Dirty(Cancel As Integer)
    If Not IsNull(Me!Client_Division) Then
        Me.Client_Division.Locked = True
        MsgBox "A CLIENT/DIV has already been selected. Please do not change."
    End If
End Sub

I've tried....

Private Sub Combo75_Dirty(Cancel As Integer)
    If Not IsNull(Me!Client_Division) Then
        Me.Client_Division.Undo = True        
       MsgBox "A CLIENT/DIV has already been selected. Please do not change."
    End If
End Sub

I have not been successful in stopping the update. Any help would be appreciated.

Thanks

Linda

[June7]

Try using the combobox BeforeUpdate event.

What if user accidentally made wrong selection the first time? Won't allow correction?