Creating a query on a search criteria

[snipered]

I have a form. If on the form, i enter the primary field, a report needs to be generated given a criteria.

My question is, how do i set up the query so i say that value of supplier in formA-when it = a value then do a report.

Heres the problem, this only needs to be temp and not permanent so i dont want to create a new table.

Hope you understand what i mean.

[Ecniv]

Initial easiest way is when you get your query to retrieve the data, use a criteria and 'build' it to point at the form.combofield.

The combo list then has to have a unique value or text value which you will filter on.

The criteria would look something like:
forms!frmYourFormName.ControlName

Depends how you run the query.


Vince