Repeating an empty query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

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

Dropdown combined with parameter query 1
Access 2007 - append query only appending 0 rows??? 0
State abbreviation MI fails in query 4
Query error, too few parameters 0
Multiple queries with same filter problem. 11
Multiple Parameter Crosstab query filter by form 1
MS 2003 Parameterized Query 0
query result in text box 2

Back
Top