Reporting only selected data on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that provides a list of parts to ship. Each part in the list
has a check box. To ship, one just need to check the part. Sometimes not all
the parts in the list are shipped at the same time, but only partial. I need
a report that shows the list of parts that is CHECKED at that time on the
form (the report may serve as a packing list.). There is button when on-click
will open the report.

My report is trying to link to the parts that are checkd on the form. The
problem I have is that the report does NOT show all the parts checked, but
only one part shows.
Does anyone have any idea or has done this before? I've spent days on this
already, so any pointers would help. Thanks in advance.
 
Samantha,
I'm assuming that your parts are in a continuous subform, and that some
of those records are checked, (ex. name ToShip is checked) and some other
records in that same order are not.
The main part of your form should have a unique identifier (key field)
for each "order" record... say for example, an OrderNo.
The query behind your report should select the particular record
presently displayed on the form by using this criteria against the OrderNo
in your query...
= Forms!frmYourFormName!OrderNo
Now, in the query, link your subform "secondary" parts records table to
your primary table, and use this criteria against the ToShip field...
True

That should find that one order record being displayed on the form, and
also all associated subform parts records that have ToShip checked.

hth
Al Camp
 
Back
Top