>Hi - I am just getting bogged down with the complexity of what I am trying to do and I am sure someone will have been here before...
>
>I am trying to write a routine that allows users to select records to be included in a mail merge - they may want to write to just one person, they may want to write to those clients who live is a certian postal area and the criteria goes on and on and on...
>
>I am trying to do it like a multiple choice thing at the moment and build the SQL statement based on the choices but it soon gets v. complex...
>
>Any pointers or ideas?
Chris,
I have User's form and couple of classes designed for this purpose. I used multiselect grid (my modification) for Towns criteria. Range class for zipcode range and textbox+list class for typing individual zipcodes (not in range). The first (draft) implementation of my classes could be found here in Download section (Input classes and Container based on Multiselect Grid class). You may take them as a start point. I can probably send you my whole class library with all classes implemented (Range class, checkbox class, Input class, MultiList and MultiGrid), if the aforementioned classes would not be enough...
If it's not broken, fix it until it is.
My Blog