Input values and then open form

[Rakier]

Help please.

I have a form that when the button is clicked to update an order, it opens an input box asking for the order number that the user wants to update. Once the number is input, another form opens with the items ordered under that order number. This works great as long as the order number exists, however it shows a blank item screen when the order number does not exist.

How can I get it to send a message back to the user if there are no items found under the current order number?

Thanks for any help.

 

[David R]

Try this suggestion: http://www.access-programmers.co.uk/ubb/Forum4/HTML/000181.html