update main from from sub form

[darno]

update main form from sub form

Hi There,

I have 2 forms form1 (Main Form) form2 (Sub Form). Form1 acts as a header form and form2 acts like a details form. both forms are connected via code No. field. i have a combo box on form2 which on selection chooses code no and assigns corresponding values to different controls on form2. there is just one field required to be filed on form1, but i simply dont have a clue how i may go about it. for filling values on form2 i use this CODE IN AFTER UPDATE EVENT OF THE FORM :

Me.CodeNo = Me.Combo111.Column(1)

please advise me how i may update one text box on form1 from same combo box


Regards,

Darno

 

[RuralGuy]

Here's a good link to put in your favorites. Refer to Form and Subform properties and controls

Post back if you need additional assistance.

 

[darno]

Here's a good link to put in your favorites. Refer to Form and Subform properties and controls

Post back if you need additional assistance.

I tried your link but stll i m clueless. I need to update my main form named HDRFORM having a text control named code No. I wish to update HDRFORM control from subform Named DTLFORM through a combo named combo111. Please help me.

Darnos

 

[darno]

Thanks Rural Guy U Made My Day...

Here's a good link to put in your favorites. Refer to Form and Subform properties and controls

Post back if you need additional assistance.

Thanks for providing such a gr8 help, and sorry being too lazy that i did not look at the link that u referred to. anyways finally i got the heck. But all thanks 2 U

I m one happy man on this earth.

Thanks again

Darnos

 

[RuralGuy]

Hi Darnos,
Glad to hear you got things working. I noticed something in your posts that I think is giving you some problems: embedded spaces in a name. Here's some links that are worth reviewing on that issue.
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases