Access 2002: Reports Label question

D

D.M

I have reports label and I want to print precisely one or two bar code
(member_id) for the specified member but not for all members, just for the
selected.
How can I make this selection which members bar code I want to print?
Thanks
 
A

Arvin Meyer

D.M said:
I have reports label and I want to print precisely one or two bar code
(member_id) for the specified member but not for all members, just for the
selected.
How can I make this selection which members bar code I want to print?
Thanks

Use the where clause in your report when you open it:

DoCmd.OpenReport "YourReport", , "member_id=" & Me.txtmember_id

Me.txtmember_id represents the name of the textbox on your form which holds
the member_id value
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top