I have several many:many relationships for my main table PRODUCTS. PRODUCTS ProductID and CUSTOMER CustomerID are linked in a 1:many relationship as foreign keys, and together form a concatenated primary key for the table PRODUCT_CUSTOMER_RECORDS. I have about 6 such relationships all related to PRODUCTS.

Problem:
1. How do I create a form based on these tables.
2. How can I program a "duplicate record" command for this form without getting a "run time error" all the time.
3. How do I filter these records

You can't really create a single form to work with multiple many-to-many relationships. You can create a form with nested subforms (up to three levels total) to work with hierarchical structures such as company-order-order items. You can use a form with multiple un-nested subforms to work with multiple many-to-many relationships such as class-students and class-teachers and class-schedule. In this case you would have a main form for class with three subforms. One each for students, teachers, and schedules. You can also use tabbed forms to effectively depict this information.