Creating a dynamic report (beginer question)

[Guest]

I want to create an invoice (report) that pulls information based on a form
but not always do i want all the information to appear on the invoice, how
can i make it that i will be able to check off boxes next to the diffrent
items, then click "print invoice" and then the report will only print what i
have checked off.

 

[Sergey Poberezovskiy]

Just base your report on a query that selects
only "checked" items.

HTH.

 

[John Vinson]

I want to create an invoice (report) that pulls information based on a form
but not always do i want all the information to appear on the invoice, how
can i make it that i will be able to check off boxes next to the diffrent
items, then click "print invoice" and then the report will only print what i
have checked off.

First thing to realize: A Report does not pull data from a Form. It
pulls data from a Table, or (much more commonly) from a Query
selecting records and fields from one or more tables. Data is stored
in tables; edited and entered using Forms; combined using Queries; and
printed using Reports.

What you'll need to do is use a Query which references controls
(checkboxes or perhaps other types of controls) on a Form to select
which records you wish to print. You may want to look at the Orders
application in the Northwind sample database for some ideas on how
this can be done. If that doesn't help, please post back indicating
your table structures and how you decide what to print.

John W. Vinson[MVP]