How to open current record to form

[number2]

I need to print out just the current record. i.e, I have a text label with the following event procedure to print a mailing label, in this case for the attorney attorney in the record. The code I used below prints ALL records with the same attorney name, which means I may get multiple labels, as some patients share a common attorney. I need just ONE label to print, not all occurances of the specific attorney name. Any help?


Dim strCriteria As String
strCriteria = "[QME/AME Information]![attorney]=[Forms]![QME/AME Information]![attorney]"
DoCmd.OpenReport "attorney Label", acViewPreview, , strCriteria

 

[MangroBongacello]

number2,

...as some patients share a common attorney...

What is the record source of your report? From your post looks like you are using the patients and not the attorneys table. In the attorneys table a particular attorney shouldn't be duplicated.

If you don't have separate tables for attoneys and patients (which you should have), you can use Group By so only one occurance of the attorney will be shown.

Hope it helps

Mangro

 

[number2]

I have a separate attorneys table from which their information is lookup into the patients file. I am trying to print the attorney label from the patients record. I hope this makes sense. It is very frustrating..easy things are always hard, and hard things (with great help from this group!) are easy!

 

[MangroBongacello]

It doesn't make sense. Why don't you use attorneys table for the report?