Hi

Fairly new to Access 2K and have created a simple address book, which I want to be able to print labels from a Main Menu, using a command button. When I used the Label Wizard, I entered the table, tblContacts, but when I click on the button, the Menu is printed and not the labels.

Can someone enlighten me please? :rolleyes:

When posting please post your question once and to the relevant forum. Your other posts have been deleted.

Rum Rat, design a query 'qryCustomerLabels'. The query should include Contact + Company Details so will probably be made from tblContacts + tblCustomers (whatever you named them).

Go the the reports Module and use the Label Wizard. I suggest for the Title and Contact Name you do something along the lines of:


=Trim([Title] & " " & [FirstName] & " " & [LastName])


Hope that helps.
Phil.