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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

teresa - 01 Mar 2007 18:33 GMT

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.

Reply to this Message

kingston - 01 Mar 2007 18:59 GMT

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

Msgbox "You have selected this field."

>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.

Reply to this Message

teresa - 01 Mar 2007 19:11 GMT

Too easy :) Thank you very much.

> Use the control's On Click event and something like:
>
> Msgbox "You have selected this field."
>
> >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.

Reply to this Message

Ofer Cohen - 01 Mar 2007 19:08 GMT

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

Signature

Good Luck
BS"D

> 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.

Reply to this Message