OK - I understand your clear reply, but I still can't get filtering to work in the following situation.
The users of a volunteers' DB have a new requirement which is to email a number of volunteers at the same time. I produced a form for the volunteers' DB which lists everyone with an email address, allows non-contiguous selections and then invokes an email with the names in the bcc field.
The DB, however, uses Steve Nyberg's extremely sophisticated report filtering suite (Rfil5 – unfortunately the webpage
www.stevenyberg.com seems to be no longer available but the package is offered widely on the internet) and the users want to retain the flexibility of this custom filtering when the drop down list on the form is created. I've managed to introduce the form into the suite, but it won't filter the displayed records.
The supplied DB opens on the Custom Filtering form.
- Choose Volunteers by Duty in the top left 'Report' field and then click 'Preview Filtered Report'. The report shows Volunteers by Duty.
Close the report and on the Custom Filtering Form, in the first 'Select Fields' field, choose 'Duty Name', set Expressions to '=' and set 'Values' to 'Clerical'. Preview the report, and it is filtered to show details of only the chosen duty.
Now select 'MultiMail' in the top left Report field. (Ignore warnings to save custom filter.) Click on the 'MultiMail' command button at top right and a form containing a list of 12 email addresses is produced.
Close the form and select DutyName = Clerical on the custom form, click the MultiMail button and the list is not filtered. I can't find out why.
Notes
1. When a filter has been chosen, the 'Where' string the Rfil suite will produce can be seen by clicking the 'Refresh SQL' button on the custom filtering form.
2. The MultiMail list box uses query
MultiMailAddresses as its row source and this query is based on
MMA1. This is because it has to do a Select Distinct (volunteers can have more than one duty) and I don't think this can be done/don't know how to do this in one query.
3. The main VB module is
z_Rfil5_basMain, and the report/form calling routine is
rf5CRun
What am I doing wrong, please?
Thanks
Silverback
You do not have the required permissions to view the files attached to this post.