Doing labels is relatively easy (once you know how). Create a new report and make the Detail section as large as one label. Now add the information you want to see on the one label, like you would with any other report. Now for the trick, go into Page Setup and go to the Columns tab. In there you can define how many columns you need (for Avery 5160 you will need three). Then set the Column Size to Same As Detail and the Column Spacing to about an eighth of an inch. The Column Layout you can decide for yourself which works best.
You will also want to change the Top and Bottom margins to .5 and the Right and Left to .25.
The real trick comes when you want to use partial pages of labels. That is more complicated.
It didn't work for me. When I followed the steps you gave me, and then looked at my labels in Report View, it only showed one label and my info was not shown.
I know how to use the Label Wizard to create labels. But I don't know how to pull up address labels using the combo box I created for only those individuals associated with a specific program.
For example, say I wanted to send a mailing to only the individuals in a certain program...I want to be able to click on my combo box selection (which is by name of program) and have it automatically pull the Avery address labels for just those people.
Open the report using a filter. There is a WhereCondition parameter in the DoCmd.OpenReport that will filter the report for the matching data. If you are familiar with SQL then it is basically everything after WHERE in an SQL statement.
1. Your combo box is named cboProgram~(The name is "ProgramComboBox")
2. The Program ID is stored in the ProgramID field~Yes
3. Program ID is the bound column for the combo box~Unknown...Row source type=Query and Row Source=SQL Statement with Program ID, Name of Program, and Initial Date of Participation
I'm getting a message that says "some data may not be displayed. There is not enough horizontal space on the page for the number of columns and column spacing you specified. Click page setup on the file menu, click the columns tab, and then reduce the number of columns or the size of the columns.
Then a dialog box opens up asking me to enter parameter value program id.
If I click ok to bypass that, the "all labels" report shows with "error" "error"
Your report is too wide. Add up the Right and Left margins, the column width times the number of columns and any column spacing you have. Together the total needs to be less than the page width (8.5"?).
If you are being asked for the Program ID parameter then Program ID is either spelled differently or is not part of the data that feeds the report.
What is feeding the report? A query? A table? If it is a query, can Program ID be added to the query? If not, can you show the SQL? You can switch to SQL view when you desing the query to get the SQL code.