query

[Guest]

I have a form with query behind it. When I run the query there is a
pop up window saying "Type in the ID number" to get the post I am looking
for.(which works fine) but if I type in a ID number that doesn't exist I get
a blank form.
Instead I want an error message saying:
"ID number doesn't exist"

 

[Jeff Boyce]

Consider another approach...

If you create a form with a combo box on it, and base that combo box on ONLY
legitimate ID#s, you (and your users) will NEVER enter an incorrect ID#.
Then you can modify your parameter query to look to the form to get its
criterion value. Of course, this way, you'd always have to have the form
open first, and a value in the combo box.

 

[Guest]

Thank you very much !
/m

"Jeff Boyce" skrev:

Consider another approach...

If you create a form with a combo box on it, and base that combo box on ONLY
legitimate ID#s, you (and your users) will NEVER enter an incorrect ID#.
Then you can modify your parameter query to look to the form to get its
criterion value. Of course, this way, you'd always have to have the form
open first, and a value in the combo box.

--
Good luck

Jeff Boyce
<Access MVP>