Discussion Locked

Access 97 Parameter Prompt?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The way we currently run queries which have the choice of criteria in different fields, you are repeatedly prompted. For example, the first box might read, "enter code", the next "or enter state initials", the next "or enter store #". We have new users who don't know when they get the first prompt that they will have other choices.

I'd like a way to display one box which lists each of your choices and allows you to enter criteria. Is this possible?

3 replies

by learneverything

Thanks for your help. I'll need to do more research in order to make it work. I hope to get back to it sometime soon. Now I know it is possible.

I know you were willing to work with me further on this, but I'm afraid I don't have the time to devote to it at the moment. This question was in danger of being closed due to inactivity, so I wanted to be sure to award you points.

Thanks. :-)

This discussion is closed to new replies.