How do I do Subform to Subform field updates?

  • Hi,

    I have 1 main form and 2 subforms. Each of these 3 forms has its own table.

    Mainform table has "CustomerNumber" as Prime. Key

    Subform 1 table has "Unique ID" as Prime Key and has a many field for CustomerNumber

    Subform 2 table has "Service" as PrimeKey (but does not link to any other field), and also has many field for "CustomerNumber", AND a many field for "Unique ID".

    I want Subform2 to have it's many field of "Unique ID", to be updated, at the same time it's entered or incremented in Subform 1. How can I do this?

    Thanks,
    Jim


  • I don't know if you ever solved this, but I thought I would chime in, since I just saw the post and noticed no one had replied.

    I'm not exactly clear on where this Unique ID field is created (subform1?) but, in general, the following will allow you to update subform2 from subform1.

    Put the following in the proper event on subform1 (AfterUpdate of UniqueID, AfterUpdate for the form, AfterInsert for the form, whaterver). (this should be all one line)

    Forms![MainFormName]![subform2ControlName].Form![txtUniqueID] = Me.UniqueID







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about How do I do Subform to Subform field updates? , Please add it free.
    Posted by jane on January 8th, 2009 Filed in iraquideaths.com edit
    Shropshire Solicitor Divorce Warning To Wealthy Husbands Regarding European Court Of Human Rights!
    Do you Need a Dog Trainer in Austin?