syntax for using combo box to disable field

[shay]

Try this ...

Private Sub Form_Current()
Me.LocationId.SetFocus
Me.AreaLocation.Enabled = (Me.LocationId.Text <> "Hamilton")
End Sub


Private Sub LocationId_AfterUpdate()
Form_Current
End Sub

hth

shay

 

[chewy]

HOT DAMN THAT WAS IT!

Thank you so much!!

Works like a charm!