Select one customer label?

[Dustin]

How do I select one customer label to print from the label report?

Thanks,

Dustin

 

[Al Campagna]

Dustin,
Using your recordset form, find the record you want, and using a unique key field value
(ex. CustID), use the OpenReport Where argument...
DoCmd.OpenReport "rptYourReport",,, "CustID = '" & [CustID] & "'"
(form must remain open during report)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Dustin]

I am not sure that I understand. I thought it was possible that when you
opened the label report it would ask you which customer you wanted. And you
could choose the one customer or all of them. Maybe it would help to know
that I am making labels based off a query.

Thanks Dustin

Dustin,
Using your recordset form, find the record you want, and using a unique key field value
(ex. CustID), use the OpenReport Where argument...
DoCmd.OpenReport "rptYourReport",,, "CustID = '" & [CustID] & "'"
(form must remain open during report)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

How do I select one customer label to print from the label report?

Thanks,

Dustin

 

[Al Campagna]

Dustin,
Well you could do it with a parameter in the query, but using the WHERE arguement in
the OpenReport method does the same thing, and allows one report to operate in 2 modes
(One or All).
It tells the query to limit the reults to that one unique Customer record your on in
the form.

Given a PrintAllLabels button on your form, just open the report without the WHERE
argument.
Given a PrintThisLabel button, use the WHERE argument to print just the Customer being
displayed.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I am not sure that I understand. I thought it was possible that when you
opened the label report it would ask you which customer you wanted. And you
could choose the one customer or all of them. Maybe it would help to know
that I am making labels based off a query.

Thanks Dustin

Dustin,
Using your recordset form, find the record you want, and using a unique key field
value
(ex. CustID), use the OpenReport Where argument...
DoCmd.OpenReport "rptYourReport",,, "CustID = '" & [CustID] & "'"
(form must remain open during report)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

How do I select one customer label to print from the label report?

Thanks,

Dustin