No, you can't do But a good solution is to simply put two sub-forms side by
side on a from.
Take a look at the "last" screen shot here:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
The above shows a classic check register where on the left side you have
many people who are donation money, and on the right side, we have to split
out that amount (just like quicken does). You can see this is a "many" to
many.
Take a look at all of the above, and you can see that "most" of the example
screens are in fact two sub-forms placed side by side...
In the master form (which is now a subform), that shows all of the
people donating, you can in the on current event, you
place the following command to make the child forms on the
right side follow this form.
me.Parent.Child2.Requery.
and,
In the link child/master settings for child 1, you place:
linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID]
