Message Box (1 Viewer)

[SteveF]

Need some help with a message box if possible, thanks in advance.

I have a text box that the user enters a number into between 1 and 5. I can use the validation rule in the table and that works nicely, the trouble is that I don't want the standard Access message box.

I've read through the forum and can now make my own message box, which I'm pretty pleased with, but have no idea how to apply the validation rules.

Can somebody point me right?

 

[jdraw]

What exactly are the conditions under which a MessageBox should appear?
What is the logic associated with this?

 

[SteveF]

The message box should appear when the user enters a number higher than 5. The message reads 'please enter a number between 1 and 5'

It's a form that is tabbed through and this is a textbox. It's a '5x5' risk assessment so only numbers 1 to 5 should be used.

 

[jdraw]

You might consider a small combobox with values 1- 5, they have to choose one.
That way you could avoid error message completely.

 

[SteveF]

How would that work in the table though? I'm entering the numbers into a table, does a combo box not need a list of stored numbers to pick from?

 

[jdraw]

Yes , you could have a value list in the combo and limit to List.
What exactly are you storing in a table? Or are you reading a value(1-5) from a table?
I was just tying to limit the selections to 1 thru 5. (No spelling mistakes, no alphas, 8, 9 or 30.)

 

[SteveF]

I didn't think of other things being entered, you have to think of everything don't you?

The numbers, 1 - 5 , are stored in a table and queried from there so inputting the number ( I think ) is necessary.

 

[SteveF]

Just tried that and it worked a treat, thanks

 

[jdraw]

You are welcome. Good luck with your project.