Parameter box to print one lable for two people at same address

[garyf]

I'm trying to print one label for two people at the same address following
the sample given at
http://support.microsoft.com/default.aspx?scid=kb;en-us;207753&Product=ass
for ACC2000.

When I run "qryMailingList" a parameter box appears. If I click on it
without inserting anything, the Name2 field is blank. If I put a name in it,
then Name2 is that name for everybody. The field is as follows: Name2:
IIf(qryLabelNames1.ListName=qryLableNames2.ListName,"
",qryLableNames2.ListName)
Any suggestions?

 

[[MVP] S.Clark]

The import part is the name of the parameter in the prompt.

Is that name part of your query or table?

 

[garyf]

I finally determined the problem. I had incorrectly spelled one of the
queries. It now works. Your answer is right on, I just didn't catch the
error for a long time. Thanks for your response.