Moving between forms with a data relationship

[Raddy]

How can I enter a record in a form1 then navigate another form from within form1 form to add a records that are dependent on form1.

I'm not sure if this is possible - should I just exit form1 then select the option to enter the servant form?

 

[MStef]

Yes, it's possible. Make a Form1 (main form).
Make a form2 (subform). Open Form1 (design view).
Put form2 in form1 as a subform (via Toolbox,
subform/subreport icon). Link them via
"Link child fields", "Link master fields",

Look at "DemoSubA2000.mdb" (attachment, zip).
Open "frmMain" and see.

 

[Raddy]

Doh! I didn't think of that!
thanks

 

[Raddy]

Doh! I didn't think of that!
thanks

Can I condition this to be just on Adding a record to form1- that is disable the form2 (or non-display) if I am amending records on form1

 

[MStef]

Yes, you can make your subform UNVISIBLE,
and use it when you need. Open frmMain and see.
Look at "DemoSubFormA2002.mdb (atachment, zip).