Changing the criteria on a query via a Form

[paulm]

Hi

Not sure if this is in the right forum.

But here goes, my question is;

Is it possible to update the criteria by using a form?

What we are looking to accomplish, is a report that prints out labels in relation to the customers that are chosen in the query. What we want the user to be able to enter multiple Company ID's on this form, which are then picked up by the query and the companies name and address printed out via the report.

The printing out of the report from the form we have done.

 

[neileg]

Create a control on the form that captures the criteria.

In the crieria box on the query grid refer to the control like this:

Forms.MyFormName.MyControlName

From what you say a multi select combo may be the appropriate way of selecting your customers. Do a search in these forums for halp on this.