Guys,

I have a problem with accessing a report in Access!

The problem is this: I have a user form with some combo boxes where the user can make a selection and the selection is passed to an SQLWhere function that then executes the Report to display the report. The report works with the combo box, but it only works after I have filled in a Parameter Box that pops up after the user has made a selection from the combo box.

Is there away that stops the parameter box from popping up on the screen?? That is to say that the user choice gets passed directly to the report!!!

Regards

Welcome to Utter Access Discussion Forums!!

The basic technique for using form control values as criteria in parameter queries is illustrate here . The form with the combobox must be open when the query starts. I generally use a button on the form to trigger the report.

Glenn