Creating a query on a search criteria
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.
Re: Creating a query on a search criteria
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