Unanswered: Printing mailing labels for specific customers...
I was wondering if someone could help me! If so, I would be extremely grateful!
I have created a table called Themes and this table has a field called ThemeID. This is simply an AutoNumber field, and has a corresponding theme name, i.e. 1 = South Africa.
Now, there is also a field called ThemePreference contained in a Customers table. This contains a number, which is based upon those taken from the Themes table. I have created mailing labels using the Report Wizard, and what I want to be able to do is to click a print button on a form and then get asked for a value, e.g. 1, into a text box on a form, and for mailing labels to be printed out for every customer who has 1 (i.e. South Africa) as their theme preference.
How is this achieved? I've basically done it all apart from creating the button…
I am double-clicking the report, and then it is asking to enter the ID number (as I wanted), so I enter 1, and then it asks again! I enter 1 again and then it just displays all of the customers on the report and not only those with a 1!
Also...this may sound a very stupid question, but my friend made the forms from the Wizard, so I've had to go through all of the forms now and sort them out! As he used the Wizard, it has one of the background patterns set on the forms. I don't want these and just want to have a background colour, but when I change the background colour, it doesn't change - it won't change the standard wizard background pattern to a background colour!