how do I print a label for a single record in my database,

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up my database to print Rolodex Cards for the office.
Once I print the entire database, I will need to be able to go back in later
and make revisions as needed and print a rolodex for just a single record.

How can I do this?
 
DDock,
Each of your Rolodex records should contain a unique key field
identifier. Say... CustomerID.
In the query behind your report, use a criteria to filter out all
records, to print just the one where the CustomerID = the value on the Open
form.
Using your own form and control names... use this criteria against the
CustomerID field in the report query...
=Forms!frmYourFormName!CustomerID
 

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

Similar Threads

Printing from different queries 1
Are there other print options for outlook? 1
Printing Labels but designating which label on sheet to start prin 5
Printing a report for a single ID 1
Printing on 3x5 Rolodex Card Stock 2
Setting a total height per reccord in a report 2
Multiple mailing labels single record 3
Can I print a single mailing label from a report in access? 1

Back
Top