Repeating an empty query

E

EliotF

I have a query that depends on an input box. I would like to add a failsafe
to the query so that if the input box is wrong or mis-spelt the user is
re-prompted or some action takes place, ideally I would like the query to
repeat and re-present the input box.

What I don't want is for the balnk query to be returned.

Can anyone help?
 
D

Duane Hookom

Move away from using parameter prompts. Use controls on forms which allow
combo or list boxes as well as code or other to check the integrity of the
user input.
 
Top