Opening another form by double click

[chrisjack001]

I have a form in Access 2007 Database called ReqsAndCategories Subform. When I DOUBLE CLICK a name in the Individual/Group field on that form, I want another form called VendorsNew to open with all the records for that name clicked on in the ReqsAndCategories Subform.Can you pleasehelp me with a code I can use in the Double Click Property field or a better option.
Note Attached are copies of both forms and the design view and Record Source of the Individual/Group field in the ReqsAndCategories Subform that is the same with the Compressed Person Name field in the VendorsNew table with only the -(FY) field that is attached to the name.

[ajetrumpet]

you'll use this code:

on double click 'for reference only

docmd.openform "newvendors", , , "[vendor] = '" & me.vendorfield & "'"

alternatively, you can use the last argument in the above command to open it and reference a field on the subform directly using OPENargs:

docmd.openform "newvendors", , , , , [vendor]

that may not be entirely accurate, so check help if noone else offers a more direct solution. also, I didn't count the commas, so the count of them might be off. again, the help file on "openform" will show you the exact num of args.

[vendor] is the fieldname of form 2 for which to filter on.