Still Having Problems with Macro!

[euphonium01]

I have a Where Condition in a OpenReport Macro, [Serial #]=[Forms]![BBIS Extended Subform]![Serial #]

The above opens the correct 'Serial #' record when I have the 'BBIS Extended Subform' open on its own, however, when I open the Main form that contains the subform I get a box asking me to Enter Parameter Value?



I tried the following: [Serial #]= [BBIS Extended Subform.Form![Serial #] this opened the Report but, the Report contained no data at all, let alone the correct 'Serial #'

I've tried various suggestions from helpers but nothing seems to work, except when the subform is open standalone it works perfect, if I had hair I'd be pulling it out!!!

[ranman256]

The macro cant interpret it correctly...if you use code it would look like
"[Serial #]=' " & [Forms]![BBIS Extended Subform]![Serial #] & " ' "

OR
build a param query that has : [Forms]![BBIS Extended Subform]![Serial #] in the critera under SERIAL field.
then just open the query in the macro.

[euphonium01]

Hi ranman256. You nailed it, spot on, the parameter query works brilliantly and as a query I can add a few other useful bits into it. I knew immediately I read your answer that it would work and was able to create the query no problem, I know what to do but it's having that foresight (that experts like you have) where I fall down. Thank you so much for your help