well it's not too late, I knew there was something wrong with what I
created...
I created a table of data with fields for names, address, phone etc but then
I wanted to be able to filter each person based on one or several
characteristics. (It's a collection of names for an annual event so the
yes/no fields I created as Author, Speaker, Boardmember, Speaker's Guest, but
of course some people are more than one box,
then I created my form so I could just enter the names and check whichever
box pertained-
but that's wrong huh?

"Jeff Boyce" wrote:

If you created your form before you had any tables for data, then yes, you
did it backwards.

Access is a relational database ... it all starts with the data.

By the way, if you have need for "10 yes/no boxes" today, what's to prevent
you from needing 9 or 11 (or 23) tomorrow? This is also something of an
indication that your database/application may not be designed in a way that
lets Access do what it does best.

If you'll provide more specific description of your data, folks here may be
able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"shumate62" wrote in message
...
Help the desperate newbie!
Did I design my database wrong? I created a form with basic name, address
etc. then also include about 10 yes/no boxes to be selected depending on
the
type of client, some clients have no boxes checked, some have one and some
have several. I see how to filter the form to search it- and that narrows
it
down, but when I run a report for labels every name comes up!
How do I run mailing labels for a filtered result?



.