parameter using a lookup field

K

KelD

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??
 
D

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.
 
K

KelD

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.
 
D

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.
 
Top