On one of my forms, when I run the save button I have 2 labels print out.
Field [Unit] is the main key in my main table.
below is the code I am using to print these labels:
Code:
Select Case MsgBox("Do you Want To Print RSO Labels?", vbYesNo, "Warning")
Case vbYes
DoCmd.OpenReport "rptRSOLabel", acViewNormal, , "[Unit] = " & [Unit], acWindowNormal
DoCmd.OpenReport "rptAccessory", acViewNormal, , "[Unit] = " & [Unit], acWindowNormal
Case vbNo
End Select
The problem is that "rptRSOLabel" prints the [Unit] number sometimes. About 1/10 times the number doesnt print.
The part that really confuses me is that "rptAccessory" prints the [Unit] number consistently.
Any input on this would be helpful.