Using a form to get information for making mailing labels

S

stag246

I have a Main form which i want to use certain information to help narrow and
choose certain people to create mailing labels for. I want to be able to make
choices based on 5 factors: County, Program, County and Program, Coordinator,
All the above.

The names of the fields are as follow County (cmbCounty; which is a combo
box), Program (lstbxProgram; which is a list box, and has multi-select
enabled), Coordinator (cmbCoord; which is a combo box). Is there a way to use
VB coding (I am pretty rusty with it) to set up something like...

If county is not null run for that county.
If programis not null run for that program.
If county and program is not null run for that county and program.
If Coordinator is not null run for that Coordinator.
If all are null run for all.

Which will set up labels based on that criteria. Should I try setting this
up in a query using sql? Thanks for any help on this.

Jeremy
 
Top