Saving main record once the subform has a record!!!

[DaniBoy]

Hello all,
This is what I mean by the Title: I have three tables that I put into a single form. Table1 has a One to Many relationship with Table2 and Table2 has a Many to Many relationship with Table3.
When I created the form on Form Wizzard it automaticly gave me the Table1 as the Main form and Table2 and Table3 as subforms.

Now, when I input the necesary information on the main form and then go and start inputting the necesary information on sunformTable2 the Primary Key of Table1 is automaticly inserted as the Forien Key on subformTable2 Forien Key field. Now When I click on the subformTable3 and select somthing from my drop-down box I expect to get the Primary Key of Table2 on the forien Key field on subformTable3. Well, it does not happen. The reason I think this does not happen is because the records that I inputed on the MainTable1 and subformTable2 are not saved. Once I click either next record or previous record and come back to the record I am able to click on my subformTable3 and the fPrimary key of the subformTable2 appears.

What I need is to have a code that saves the main record once I input a record on the subformTable2.

I have tried to send the file but it says is to big, its only 256k.

Thanks
DaniBoy

 

[DaniBoy]

I figure it out guys!!

Thanks I got it to work!!

 

[sondriven]

Hi,

Im having a similar problem. What was your cure for this?

Thanks.

 

[Phonesa]

Can you post how you got it to work? Thanks.