Selecting info before passing it to a report

[Amy]

Hi,

I've tblClaims and tblClients among others. I need to create a report
selecting a client and some of its claims trough a form. So I thought to
create a combobox to select a client and a subform to list all the claims in
a datasheet format. From the list shown on the subform, I need to pick and
choose the claims to be shown on the report. HOWTO do it? I imagine I'd need
to add a checkbox on the list and via an 'if' statement pass the selected
info to the report. If that's the case, how would I go by?

TIA

Ana

 

[Guest]

I would use a multi-select list box for the claim display and selection.
There are lots of resources on the web that explain how to use a multi-select
list box to filter a report.

 

[Al Campagna]

Amy,
You've pretty well answered your own question.
The combo would list all clients, and would capture the ClientID, and
use that ClientID to link the subform to the main form (Parent/Child)
Add a Boolean field to your subform table (you could call it PrintMe),
and use a check box to select the sub records you want.
You'll be using your ClientID in your query behind the report, and a
simple
= True criteria to the PrintMe field.

I usually add 2 buttons to the subform... SelectAll and SelectNone.
SelectAll runs an update query to change PrintMe to True for all records,
and Select none to set PrintMe to False on all records.

But, all this might not be necessary, if there is any logic as to what
subform records you want on the report.
For example... all records for this client that fall after a certain
date... or...
all records that have a certain balance etc..etc...

If there is a logic to it... use that logic, rather than selection
checkboxes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."