How do I attach a warning message to fields in a form in Access?

[teresa]

I have created a form and would like the users to be "warned" when they
choose a certain field that tey are choosing that particular field.

 

[kingston via AccessMonster.com]

Use the control's On Click event and something like:

Msgbox "You have selected this field."

 

[Ofer Cohen]

You can use the field before update event to check the value selected, and
prompt a message if it's a certain value

If Me.[Field Name] = 1 Then
MsgBox "You have selected the wrong value"
Cancel = True ' If you don't want the field to be saved with the current
value
End If

 

[teresa]

Too easy Thank you very much.

Use the control's On Click event and something like:

Msgbox "You have selected this field."