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.