I have to open a report with Where statements. The current record in my form. The code works on the first click and so it stops working. Do someone have some tips about that? Can I update the record view or something.
How can I go thru all records and make a report on the current record always?
Private Sub Command35_Click()
Dim strWhere As String
strWhere = "[Feil_problem!feil_Id] = " & Me.feil_Id
DoCmd.OpenReport "Rapport", acViewPreview, , strWhere

It looks like it should work to me. You might try:
strWhere = "[feil_Id] = " & Me.feil_Id
DoCmd.OpenReport "Rapport", acViewPreview, , strWhereI would not think that the table need be specified but again, I think your code should work all of the time.