parameter using a lookup field

[Guest]

This is what I'm trying to do...I'm sure it's simple, but I can't seem to
make it work.

I have a parameter set in a query to define what info the person wants.
But...I would rather have a drop down box to choose the value.

Can this be done??

 

[Douglas J. Steele]

Create a form with the appropriate combo box on it, and base your query on
that form, rather than putting a parameter name in the query.

 

[Guest]

I can't seem to get it to work. I changed the report to a combo box, but I
couldn't get anything to work. I'm using the switchboard manager which is
suppose to bring up the report according to the query. There isn't a place
to input the control source. And I can't make the report do what I want it
to.
Thanks anyway.

 

[Dave]

Don't put the combo box on the report, put it on the switchboard. However,
if you're using the Access switchboard manager, it's going to be tricker,
and you might be better off doing your own switchboard form(s). If you "roll
your own" it will be easier to have the combo box appear only when you want
it to and manage the report selection with your own code.