Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Always get a black label when printing a Single Record Label

Status
Not open for further replies.

number2

Technical User
Oct 25, 2001
284
US
I hope someone can help with this:
When I try to preview/or print a record report label, I always get an empty black label. Is this a page layout problem? It happens on all labels reports. I access the preview/print from a button with the following event procedure:

Private Sub Label290_Click()
Dim strCriteria As String
strCriteria = "[QME/AME Information]![lastname]=[Forms]![QME/AME Information]![lastname]"
DoCmd.OpenForm "Notification Form", acNormal, , strCriteria
End Sub
 
I don't know if there a relationship between that and your black label but I'm very surprised with your Where_Condition:
strCriteria = "[QME/AME Information]![lastname]=[Forms]![QME/AME Information]![lastname]"

1) Could you try:
strCriteria = "[QME/AME Information]![lastname]=" & [Forms]![QME/AME Information]![lastname]
or, if <lastname> is alphanumeric as I feel:
strCriteria = &quot;[QME/AME Information]![lastname]='&quot; & [Forms]![QME/AME Information]![lastname] & &quot;'&quot;

2) is the field [QME/AME Information]![lastname] in the RecordSource (Table or Request) of your report? It have to.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top