insert records in a "one to many" relationship table form 2

[miguelst]

Good morning,
Yesterday I sent a question, but I think I was not very clear. I’ll try to explain better my difficulty.
I created with the wizard a Form with a SubForm, for 2 tables with a relationship "one to many".
When I insert one record in the main form, I would like to insert automatically several records in the subform. Is it possible?

 

[Crowley16]

yes, but not through the wizzard.

you would have to write some code to do the inserts.

--------------------
Procrastinate Now!

 

[miguelst]

Could you explain please. maybe some clues about those lines of code?

 

[PHV]

Tip: in the AfterInsert event procedure of the main form use some DoCmd.RunSQL "INSERT INTO ..." or play with the subform's Recordset.AddNew method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[miguelst]

Thanks, Problem solved!