Forms - Report Printing

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

Guest

I would like to have a form overlay a query. On the form would be check
boxes next to each line of the query results. I want to be able to print the
form header and only the selections of the query results where the boxes get
checked by the user on the form. How do I do this?

Basically the query will pull order header information (all of the ship to
information, name, address, etc) and it will pull all items associated with
the order. On the form, the form header will be the ship to infomation and
the form detail will be all of the items on the order. When the form comes
up, lets say it has 10 items in the detail section. Now, let say we are only
going to ship 8 items, I want the user to be able to put a check box next to
each item that is shipping. Then when we print the form, the only thing that
will print is the header information, and the details information where there
the check box is check. Thanks
 
Sean,

Firstly, Access doesn't provide much flexibility in printing forms.
Fortunately, however, you can create a report definition that looks like your
form and print that.

My approach would be to modify the main table in the query to include a
Yes/No field named Print. When the query is first executed, I would first
execute an Update query that would set all Print values in the table to False
to clear values from the last query execution.

Create a second query just like the first, except with the criteria Print =
True, and make it the RecordSource of your report. Let the user select the
ones he wants from the resultant list, and open the report with a command
button.

Hope that helps.
Sprinks
 
Back
Top