Command on two reports

[Lee Brown]

My problem is that I have a standard contract which is stored as a report and printed from our main form via a command button. The contract has been updated and I wish to store and print the new contract in a similar way. However if I change the report the changes are reflected through ALL the records, this is not desirable.
I have made a second report with the changes but again if I link it to the command button this triggers the same report for ALL the record - again not desirable.

How do I keep one command button that will print one report for say contacts 1-100 then print reports for 101- onwards?(Contract numbers are sequential and individual.

I would prefer NOT to have yet another button on the foot - which I do not think will work either.

I use Access 97 - windows 98

Best Regards

Lee

 

[Guest]

-----Original Message-----
My problem is that I have a standard contract which is

stored as a report and printed from our main form via a
command button. The contract has been updated and I wish
to store and print the new contract in a similar way.
However if I change the report the changes are reflected
through ALL the records, this is not desirable.

I have made a second report with the changes but again if

I link it to the command button this triggers the same
report for ALL the record - again not desirable.

How do I keep one command button that will print one

report for say contacts 1-100 then print reports for 101-
onwards?(Contract numbers are sequential and individual.

I would prefer NOT to have yet another button on the

foot - which I do not think will work either.

I use Access 97 - windows 98

Best Regards

Lee

If you only want to print reports > = 101 then use a
filter when openning the report.

in the command button add the following

DoCmd.OpenReport stDocName, acPreview, , strFilter

where strFilter could be something like:

Dim strFilter As String
strFilter = "ReportID > = 101"

hth