Selecting specific records

[Guest]

Is it possible to create a form with a "select" field (yes/no box), to select
several items (say employees) and then output this information to a report
with only the fields selected?

 

[Larry Daugherty]

How about multi-select list box?

HTH

 

[Guest]

Hi Lori,

Yes, this is possible. I don't have an example handy for you to download,
but you'll want to add a Yes/No data type to the table that includes the
records that you wish to print. Add a check box control to your form that is
bound to this new field. Presumably, this is a subform or perhaps a form in
continuous view.

The command button code to print your report simply needs to run a report
that is based on a query, where the query includes this new Yes/No field with
a critieria of True (or, better yet, <>0).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thank you, somehow it knew it would be something easy. When you work on
something for so long it seems like you end up trying to make it more
difficult than it really is.

Thanks again.

 

[Guest]

Hi Lori,

You're welcome. I'm glad I could help.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________