Populating listbox in Access 2003??

[gazsharpe101]

Hi, I have a report that is based on a query and I wish to populate a list box on the report with a value from the query based on the values of 2 other query results, i.e. if [amount]=5 and [quantity]= 3 then add [name] to list box, where amount, quantity and name are query values.

When I run the report, I have to input a parameter, so if I set the list box record thing to the query, then I have to input the same parameter again so I was looking to maybe fill the listbox using VBA.

Thanks for your help.
Gareth.

[nico5038]

Just refer in the listbox query with the criteria to the field of the report that's filled by the parameter.
Thus the listbox automatically gets the value "passed".

Getting the idea ?

Nic;o)