Selection List for Query

[Juan4412]

Is there a way to have a drop down list to select from for your query. For example, let's say that I want to view a certain users intries. The form is set up to record the user that input the data's windows id, which interprits the data to a "Real Name" so I already have a table with the names in it. What I am wanting is to create a query that will prompt you to input the "Real Name" (which I know how to do that part) but I want the query to give a drop down box with a list of all the "Real Names" so you can choose the name from the list instead of having to know the correct format to put the name in. Is this a feasible thing?

[pbaldy]

Yes, but you can't use [Enter whatever] as a query criteria. You need to use a form with a combo or list box, and point to it in the criteria:

Forms!FormName.ComboName

[Juan4412]

It no possible, to point the query to a form where I have data saved? I must use the comboname from a form?

[pbaldy]

I'm not clear on the question. You can point to any form; my point was that to get a list of valid selections, you need to use a form. I assumed you were trying to get a listing with a bracketed query criteria, which you can't.

[Juan4412]

Sorry, I type my questions wrong. It no possible in the query to point to a table (an not a combox on the form) where I Have my names saved?

[pbaldy]

A single record in the table, or all of them? All of them is possible, either with a join or a subquery.

[Juan4412]

All of them, when you click on the query, I want it to drop down box with names in it and you choose the person you want to view data on.

[pbaldy]

You want all of them available to choose from, but the user will select one. You need to use a combo box on a form. The combo will get its values from your table with names. The user selects one and then runs your query (presumably via form or report).

[Juan4412]

So there is no way on the query to have it pop up and ask me to input name, and instead of having to input a name, I can choose a name from a drop down menu (which would be all of the names from my cbo box)

[pbaldy]

That is correct; you can only get a drop down list with a form.

[Juan4412]

What if I changed the output to a report, would it be possible to have the selection list on a report instead of a query? Or is it still not possible?

[pbaldy]

Not in 2002; reports are not dynamic (you can't click on a list). Why are you avoiding using a form? It is the normal method of interacting with the user.

[Juan4412]

Is it possible to use a form, to display the data that I am wanting to? If so, how would I set it up?

[pbaldy]

Sure, you can base a form on the same query a report is based on, or use a technique like this to restrict the records:

http://www.baldyweb.com/wherecondition.htm

My rule of thumb is to use a form if the user will need to interact with the data (add/edit/delete), a report if they're just viewing the data.