I have a report that receives its filter from a calling Form. In that form I need to select the "Housing Blocks" to be included in the filter. Currently I have a Field called "Blocks" where the user must correctly enter: ("H-1","H-2",...). I have a table BlockT that contains the H-1, H-2 etc.
I would like the user to open something on the Form that will allow him to select the blocks he wants, and I will build the filter statement by looping through his selection. There are other fields on the Form that will also be included in the Filter statement. The BlockT data changes from location to location so I cannot hard code it as in the videos above.

And many thanks