Setting up a form to print one label for a specific record

[yappy77]

I am using code for printing a label for a specific record from the following website:

** Edit ** Removed link

When I try to execute using the print button on my form, I get an error (see attachment).

Please help. I am not great with code so I will need specific code to make this will work properly.

Thank you!

Yappy

[Steven Kogan]

You have an extra line after the line separator.

Simply remove the blank line between 'msgbox' and 'vbOKOnly' and it should work.

You'll probably get a faster responses if you do need to use an attached file: people are hesitant to open attachments.

MsgBox "Can't print an unsaved record", _
vbOKOnly, "Error"

[yappy77]

Thanks Steven for your help. I changed the line as you suggested & it is working!

Would it be possible to add code to the existing code so that I could specify the number of labels to skip when printing the record specific label?

Thanks,
Yappy

[Steven Kogan]

There is an article on how to do that at:
** Edit ** Removed link

[NeoPa]

I'm sorry guys, but the rules forbid linking to competing forum sites.

If you have a question or an answer it can be posted here in full, without reference to questions or solutions posted on such sites.

[yappy77]

Thanks, Steven for all your help! I have everything working fine now.

[yappy77]

Thanks NeoPA for the heads up. I will keep that in mind for future posts.