print only one address label from my Access address book

[Guest]

I want to print only one address label from my Access address book, I don't
want the entire address book entries printed.

 

[fredg]

I want to print only one address label from my Access address book, I don't
want the entire address book entries printed.

An easy and versatile way is to add a check box field to your Address
table.
Name it "PrintThis"
Then, add this new check box field to your form.

Add a command button to the form.
Code it's click event:

DoCmd.OpenReport "AddressReport",acViewPreview, , "[PrintThis] = True"
Save the changes.

Place a check in any address record you wish to print.
Click on the Command Button.

This way you can print 1 address or many addresses at the same time.
After printing is complete, uncheck all the check boxes, either
manually or using an Update query,