Open Report from Subform Control using Macro

[euphonium01]

Hi.

I have a Subform within a main Form, the Subform is called BBIS. Within the Subform is a Control named Serial #, I have set this Control to OnClick trigger a Macro to open a Report called BBIS PrintOut. As there are a list of Serial # listed in the Subform, I would like the Report to open with the specific Serial # I click on in the Subform.

I've tried nearly all I can think of, including ="[Serial #]=" & [Screen].[ActiveControl] in the Where Condition, all I get is 'Data type mismatch in criteria expression' yet the Subform and Report get their data from the same table, so how can there be a 'Data mismatch'? or am I missing something obvious? I am a novice user?



I am using Win 7 64bit, Office 2013

PS. I know vba would be better but I need to learn Access 1st!

[ranman256]

Your example has the serial as a number. I doubt that...it is probably a text value.
put quotes around it.
[seria#]= ' " & form.control & " ' "

[euphonium01]

You're exactly right Ranman, I'm sorry if I misled you, it is a 'Short Text' field as sometimes the Serial # can include letters as well as numbers, however each record is unique. I copied and pasted the example you gave me but I get an error saying invalid Where Condition?