View Single Post
  #2  
Old April 9th, 2010, 07:58 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default labels for filtered forms

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?