you'll use this code:
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:
Code:
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.