msgbox if cell changes from drop list

[justlearning123]

was wondering if the is a way to program access so that if someone changes the cell by a drop down list to the word "Updated" then a message box appears?

[June7]

If working directly with table, then maybe with a data macro.

Otherwise, use After Update event of combobox on form.

Access has fields, not cells.

[Missinglinq]

And end users shouldn't be entering data directly into the Table. So, in a Form

Private Sub ComboboxName_AfterUpdate()
 If Me.ComboboxName = "Updated" Then
  MsgBox "Whatever message you want goes here"
 End If
End Sub

Replacing ComboboxName with the actual name of your Combobox Control.

Linq ;0)>