Printing One Label at a time

[Samantha]

I am hoping someone can give me some insight into how I fix this code to fit my needs.:banghead:

I found http://msdn.microsoft.com/en-us/library/office/aa140106(v=office.10).aspx?ppud=4 this article which explains how to make a dummy table and fill it with blank records. The author mentions that you can use a parameter query instead of a dummy table. Although, I really am not sure what to change to accomplish this
So I got my parameter qry set to retrieve the one record, I created the form and the labels.

This is where the code stops

rst.Open "SELECT * From qryProposalLabels", , _
    adOpenDynamic, adLockOptimistic

Thanks for taking a look!

 

[MarkK]

The code just stops?

 

[Samantha]

Thanks for your reply, the error message would have been useful.
It pops up as a run time error '-2147217904 (80040e10) and states No value given for one or more required parameters.

 

[MarkK]

What happens when you run the query directly? Find it in the nav pane and double click it.
Cheers,

 

[Samantha]

When I open the qry directly it display the message box
"Enter Parameter Value" Forms!frmFolderLabels!txtWhatJob
In the Criteria of the query it is set as: Like "*" & [Forms]![frmFolderLabels]![txtWhatJob] & "*"
When I enter the job number it isolates that specific job with all the information that I would like to get on the label.
frmFolderLabels includes a text box named txtWhatJob and a combo box named txtBlanks as well as two cmd buttons one for print one for cancel .

Thank-You for your time!