Auto populate linked field with key field

rbrule

Registered User.
Local time
Today, 05:49
Joined
Jan 13, 2004
Messages
108
I have a form with a main form and two subforms. The first subform automatically populates it's linked field with the data in the key field of the main form, but the second subform does not auto populate it's linked field with the data from the key field of the first subform. I have created main forms and subforms before and this was not a problem.
Is there a way to cause the second subform to automatically populate it's linked field with data from the key field of the first subform?
 
:p Hello rbrule!
Make the second subform to be a subform in first subform,
than they both together to be a subform in main form.
(MStef alias Štef)
 
Hi Stef, thanks for the timely response. The only problem with making the second subform part of the first subform is that the first subform has to be a continuous form.By nesting the two subforms together Access does not allow the first subform to be a continuous form.

How do I work around this?
 
:) Yes I know that, the first subform
in that case can't bi continuous, but the
second subform can.
 
If I have a form with a main form, and two subforms, which are both continuous forms, is there a way to have the data from the primary key of the first subform show up automatically in the foreign key of the second form?
 
Hello everyone,
I found the answer in Access help, under trouble shoot forms, subforms. You have to go to the LinkChildFields and LinkMasterFields properties of the subform and change the properties. Help gives a detailed description of the process.
 

Users who are viewing this thread

Back
Top Bottom