So you want to print 2 copies of the invoice--one marked 'Original', and the
other 'Copy'?
1. Create a table with 2 fields:
CountID Number
CountName Text
Save it with the name tblCount.
2. Enter 2 records like this:
CountID CountName
1 Original
2 Copy
3. Create a query, containing this table and your original one. Make sure
there is no line joining the 2 tables in the upper pane of the query design
window, and drag all the fields you need into the output grid. Save the
query.
4. Open your report in design view. Set its RecordSource to the query. Open
the Sorting And Grouping dialog (View menu). On the first row dialog, choose
CountID, and in the lower pane of the dialog answer Yes for Group Header.
5. In the new group header section, add the CountName text box.
The report prints 2 copies of each record (because of the Cartesian product
query), with the appropriate heading on each one.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"swingingming" <ming.mge@gmail.com> wrote in message
news:1123571112.755372.296760@g44g2000cwa.googlegr oups.com...[color=blue]
>I want to print invoices. One Original and one copy, but I don't want
> to keep 2 reports. I have 2 texboxes, How can I enable one in the first
> copy and then enable (make visible) the second?
> Thanks a lot.
> ming[/color]
