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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use the control's On Click event and something like:

Msgbox "You have selected this field."
 
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
 
Too easy :) Thank you very much.

kingston via AccessMonster.com said:
Use the control's On Click event and something like:

Msgbox "You have selected this field."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top