parameter box

[Guest]

I have reports in my database that run from queries with criteria. I would
like for the criteria (parameter) boxes that promt the user to enter a
parameter to be combo-boxes. I have no idea how to incorporate a combo-box
into a criteria box, any information would help!

 

[Pat Hartman\(MVP\)]

You can't incorporate a combo into a parameter box so you have to attack the
problem from the other end. Create a form that includes what ever controls
you need to capture parameters and a button to run the report. The report's
query can reference the controls on the form or you can pass the parameters
directly by modifying the OpenReport method code generated by the button
wizard.

 

[John Vinson]

I have reports in my database that run from queries with criteria. I would
like for the criteria (parameter) boxes that promt the user to enter a
parameter to be combo-boxes. I have no idea how to incorporate a combo-box
into a criteria box, any information would help!

Create a little unbound Form, I'll call it frmCrit. Put your combo box
(cboMyCombo) on it. Change your criterion to

=[Forms]![frmCrit]![cboMyCombo]

It's handy to put a command button on frmCrit to open the Report
directly - the user need only open the form, enter the criterion (or
multiple criteria on multiple controls), and click the button.

John W. Vinson[MVP]

 

[Guest]

Hey Pat,
This sounds like it may work for what I want to do, however I am a little
unclear about the steps I need to take to make it happen. What I have is a
long list of equipment and I want to make reports on invoices entered by
equipment. I want it to be easy for users to enter the equipment name to see
the report without worrying about correct spelling etc., which is why a combo
box would be ideal. I hope this info helps, I really appriciate your time!
thanks, Nikki

 

[Pat Hartman\(MVP\)]

Once you build the form with the combo and button, the button wizard will do
most of the work. When it is finished, you will need to modify the
OpenReport Method so that it uses the combo control in the where argument.