Simple If Statement Help Needed

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a control on my form named Rate
I was going to put this on the after update event
If the amount in this box is not 32.50 or 27.50 I need a message box to
appear with a warning.

How can I do this?

Thanks,


Dave
 
If MyTextBox <> 32.50 and MyTextBox <> 27.50 Then
Msgbox "Wrong"
Cancel = True
Endif
 
You must log in or register to reply here.

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

Similar Threads

Help with table structure Please 1
Calculate Invoice Amount? 1
Nested IF Statements 1
Calculating a text box 9
File Download - Security Warning 5
Automatically generating text entries from combo box 4
How to change Default Value on Form 3
DCount Expression Help Needed 2

Back
Top