Open Report Problem - On Click A Field With Company Name

[aamer]

I am trying to add a code on a text box on a continues form, this form shows the list of company names.


I want to click on the text Box "CoNme" to open the Report Of The Company
The Name Of The Report Is "GP2" & the Control Source is "PurCompanyName"


DoCmd.OpenReport "GP2", acViewPreview, , , "[PurCompanyName]=""" & [CoNme] & """"

Need Help to Fix Code

[Gicu]

One too many commas:
DoCmd.OpenReport "GP2", acViewPreview, , "[PurCompanyName]=""" & [CoNme] & """"
Cheers,

[Welshgasman]

I am trying to add a code on a text box on a continues form, this form shows the list of company names.
I want to click on the text Box "CoNme" to open the Report Of The Company
The Name Of The Report Is "GP2" & the Control Source is "PurCompanyName"


DoCmd.OpenReport "GP2", acViewPreview, , , "[PurCompanyName]=""" & [CoNme] & """"

Need Help to Fix Code

Intellisense should do it?
That is what I rely on. I am not experienced enough to know how many parameters are in a command?

[aamer]

Thx Works Like A Charm