One To Many Records In A Sub Form

[Tony Montana]

I have a form set up, with a sub form in it. When I key the data in the form
it updates the sub form as it should. The problem is that some of the records
I want to key in the main form, might have multiple records in the sub form.
How do I get this to work as I can only have one record each time. Both the
form and the sub form are related to differnet tables.


Many Thanks in advance for any assistance. This is a really head scratcher
for me.

 

[John W. Vinson]

I have a form set up, with a sub form in it. When I key the data in the form
it updates the sub form as it should.

UPDATES the subform? Ordinarily it should NOT do so.

At the most, moving to a different record or changing the Master Link Field
value in the mainform should cause the subform to *display* a different
record; unless you're doing something really unusual, it should not *update*
the subform (change the contents of existing records). Is that what you mean?

The problem is that some of the records
I want to key in the main form, might have multiple records in the sub form.
How do I get this to work as I can only have one record each time. Both the
form and the sub form are related to differnet tables.

Please explain. What is the Default View property of the subform - Single,
Continuous, or Datasheet? What are the mainform and subform's Recordsources,
and what is in the Master/Child Link Field properties of the subform? Are you
trying to display multiple related records?