printing a label

[Coop]

I am trying to take customers details from a table and then print a label
with the name and address. I have set up a query, form and a report
(label), on the form I am able to search for the customer and get the
customer details from the customer ID.

The problem I am having is printing the label. When I click on the print
button the printer tries to print all the customers in the database instead
of the one I want.

So I think the two problems I am having is getting the specific customer
details I search for to go to my label and also the code for the print
command (I probably need to set up a macro, but I am not to sure about
doing this).

 

[Pat Hartman]

Look up the OpenReport Method in help. You can use one of its arguments to supply a filter that will restrict the output.