Printing Specific record

[Toni]

Hi ,
Here is my problem , I build a DB and now is working good but I need some more things to do .
I build Report based on Query , and also created a Macro based on Query to open the report with doubel click on the field , and I use this formula on query
Such as "*" & [Auftrags_Nr] & "*" , then I type the number and works good , but what I want is , can I change this so only when I klick to the field Auftrags_Nr will print the number i klick on it , and now I dont know if I have to change query or the macro?!
Any help is welcome .
Toni

 

[vbaInet]

You want to print a specific record or open the specific record on the report for printing?

 

[Toni]

I want to open a report and be able to print also . I will send you a picture of my DB so you can see it , I have for one company more Auftrags NR and I wuld like to be able to print each one .

 

[Toni]

Any Help or suggestion how I should fix this ??

Is any other way to do what I'm trying ?

 

[vbaInet]

What is the field that links the subform to the main form?

 

[Toni]

Is Kunden_Nr , aslo I can send e picture so you can see it , because I'm not one profi in DB .

 

[vbaInet]

To open the report based on the Kunden_Nr field, have a look at this:

http://baldyweb.com/wherecondition.htm

Change OpenForm to OpenReport.

We can talk about how to print it after you get the above sorted.

 

[Toni]

I found the solution for this porblem now I can print the record I Klick on it in the Auftrags_Nr in the subform.

Private Sub Auftrags_Nr_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "B_Lieferschein" ( This is the Report Name)

stLinkCriteria = "[Auftrags_Nr]=" & Me![Auftrags_Nr] ( This is the field name set with Primary Key)
DoCmd.OpenReport stDocName, , , stLinkCriteria

Err_Auftrags_Nr_Click:
End Sub

Thanks to all for the help .

 

[vbaInet]

Good job Toni!