Query multiple entries?

[Wilfy06]

Hi Folks,

I was just wondering if its possible, i'm sure it is.......
I've got a query to pull out invoices for a certain Project it brings up all project invoices and puts it into a report which works fine...... what i want to do tho is perform the same query but after i type in project code in criteria [] i then want to type peoples name or ID's that i want to print as some will be sent at different time intervals and i don't want to have to sort through invoice's to then send? is it possible? any one got any examples?

Thanks in Advance

 

[Ziggy1]

Do you mean that for a given invoice, you want to also print a reference onto it that is relevant at time of printing but not stored anywhere?

if you just, if you use a form to run the Report, then just add an Unbound text box to the form. Then go to your Report and add the Controls reference like this.....

=[Forms]![YourFormname]![FormsControlName]


With a button on the form to open the report, what ever you type in that control will appear on the report