Printing one page of report linked to record...

[ralfano]

I would like to know if someone can help me with this.

I am currently in the final stages of completing an asset database. Each computer (asset) is linked to an ID number. I have also created a "Print Label" button on the form in which when I press it, I only want it to print that page from the report. Right now, when I press the button, it prints all the pages from the report (say I have ten assets in the database). How can I go about doing this? I would appreciate the help. Thanks!

 

[ansentry]

Have a look at the sample I post here;

>>>> Click Here <<<<

This will print a report based on the form that you are currently viewing.

It also has other features that you may find helpful.

In the example the primary key (CustomerID) is numeric if your is Text you will have to make changes to the code, examples below'

Numbers:

"[Criteria] = " & Me.[MyNumber]

stLinkCriteria = "[ CustomerID]=" & Me![CustomerID] (Example)


Text:

"[Criteria] = '" & Me.[MyText] & "'"

stLinkCriteria = "[cusName]=" & "'" & Me![cusName] & "'" (Example)