Print single label

[Diana]

Is there an easy way to print a single record (ex. name,
address) on mailing labels rather than printing all of the
labels? I have set up a query to identify the record
number and pull it up but it's rather complicated. Can you
export a single record into Excel or Word and print a
mailing label easier? Thanks in advance.....

 

[Fredg]

Diana,
You stated that you made a query to identify the record wanted.
If so, just make the query the label report's record source.

However and even easier way is to have a command button on the form.
Code the click event:
DoCmd.OpenReport "LabelReport",acViewPreview, ,"[RecordID] = " & [RecordID]

Where [RecordID] is the unique prime key field of the record,
of a Number datatype.

Display the record wanted. Click the command button.