query for report

[blackcat]

i need to set up a report based on the user selecting (from a select list)
one or more options from the same field - ie 'Enter Licensor/s Required' and
have the option of entering 'joe bloggs' and 'freddy frog' and 'blah blah'
etc then enter when they have finished and have the report print the
selection. any help/ideas would be greatly appreciated

 

[Duane Hookom]

There is a generic function for using multi-select list boxes at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[blackcat]

thanks for this. however, i am no expert and am finding this a little
confusing, do i need all the elements, ie query, module, row source code etc
to make this work or are these just different methods used to get the same
results?

 

[Duane Hookom]

The form and multi-select list box are the elements that you expose to your
users to allow them to select one or more values. The module is required
since it contains the code. You also need a query since it contains the call
to the function that filters records.