Where condition

Code Builder, dont you mean Expression Builder (Right click in Criteria Field)?

If so then you should be able to Choose Field which you want to use as criteria by first finding Form and then Field
And you should end up with something like
Forms![TheForm]![TheField]

Ok - tried it by using this code.

DoCmd.OpenReport "Invoice", acViewPreview, , [Fakturanr] = Forms![Invoice]![Fakuranr]

But got the following error "can't find the field Fakturanr referred to in your expression. The field Fakturanr is presented in both the soucing form [Invoice] and the receiving report [Invoice]. Yes form and report have the same name:-)

Thanks Terry!

I found it!

"[Fakturanr]=" & Me.Fakturanr

Great :-)
You need to be aware that this will work when the criteria is numeric, if its alphanumeric you will probably need to change it to

"[SomeAlphNumericField]= '" & Me.SomeAlphNumericField & "'"

Because the text vale has to be in 'SomeText'

vale = value

Oh and dont forget to accept one of the answers so the question gets closed ;-)

!