SOLVED: Need an error message

[GaryB]

Hi everyone,

This has got me stumped but that's easy to do! I have written an estimating program for a particular printing printing press. I have limited the number of press sheets to estimate at 500! Anything over 500 press sheets will not compute a final price and that's fine. What I am trying to do is to have an error message saying, let's say for now " Do Not Enter Over 500 Sheets" appear if the total of press sheet exceeds the 500 cut off quantity. The number of press sheets shows on the form in a text box that is formatted as a general number. I have tried variations of if and end if codes and I can get it to show the string, but it pops up on any amount, not just the amounts over 500. Well that's the jest of it. Any help would certainly be appreciated.

Thanks

Gary