Re: Multiple Selection Options - table layout?

On Fri, 1 Sep 2006 06:32:02 -0700, WoodyAccess
<WoodyAccess@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

However I am trying to put in a suform for a many-to-many relationship table
into a form for one of its relationships (ie the product). What I want to
happen is that when filling out the product information (main form), the
product combo box control on the main form is linked to the product combo box
control on the sub form so that when filling out information the many-to-many
relationship is automatically updated.

You don't need, and shouldn't have, a control bound to the ProductID
on the subform. Instead, use the ProductID as the subform's Master and
Child Link Field - it will automatically fill in the current productID
from the mainform.

John W. Vinson[MVP]
.

Relevant Pages