Choosing from a List box in a query or report...............

[Guest]

right now I have [What Game] in the criteria field in a query and this give
me the ability to select a game. also when I run a report that uses this
query it prompts me for "What Game" and then it generates the report.

My challenge is this: I want to choose the game from a drop down list.
Creating a drop down list in a form works fine, but in a report and a query I
am having troubles.

Thanks for your help

 

[Tom Ellison]

Dear Tony:

I can understand how it is difficult to create a "drop down" (called a combo
box in Access) in a report or query.

You can put one in a report, but it isn't interactive. It is rarely used,
but can perform a kind of lookup. It is generally easier to just do the
lookup in the query. Not what you're looking for at all.

There is no way to create one in a query. None whatsoever.

You can only put the kind of functionality you want on a form. In order to
function, that form must be open when the report is run. The query behind
the report can reference the combo box on that control.

Actually this makes very good sense, and can work very well indeed.

Within a Jet query, the reference is:

Forms!YourFormName!YourControlName

This will reference the value in the first column of the selected row of
that combo box.

Tom Ellison