Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

synchronise two subforms

Discussion in 'Information Technology' started by realspido, Jul 28, 2006.

  1. realspido

    realspido
    Expand Collapse
    Guest

    Hi
    I have two subforms on my form which are using same reference to the main
    form.
    The main form consists main record number (Purchase order number)
    subform is a materials list for that purchase order.
    second subform is in fact query which summarises how many of these materials
    were delivered (basing on other form/table). So as result I'm getting a list
    showing how many materials from PO were delivered. Now, I want to synchronise
    these two subforms, so when I'm scrolling one, the other one follows. I found
    one post in which there was a code for current event in both subforms:

    Private Sub Form_Current()

    Dim rs As Recordset

    If (Not IsNull(Me![ID])) And _
    (Not IsNull(Parent.OtherSubFormControl.Form![ID])) And _
    (Me![ID] <> Parent.OtherSubFormControl.Form![ID]) Then
    Set rs = Parent.OtherSubFormControl.Form.RecordsetClone
    rs.FindFirst "ID = " & Me![ID]
    If Not rs.NoMatch Then
    Parent.OtherSubFormControl.Form.Bookmark = rs.Bookmark
    End If
    End If

    End Sub

    Now, maybe it's correct, but could anyone explain what [ID] is.
    Is it a lookup ID to the main form? If yes, my subform doesn't contain it.
    I've made both subforms using wizard and they contain only data I've picked
    for display on main form.
    PLease help.
     
  2. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi

    Me.[ID] or Me![ID] refers to the field called ID. In your case you would
    use
    Me.[Purchase order number field name]

    Hope this helps

    --
    Wayne
    Manchester, England.



    "realspido" wrote:

    > Hi
    > I have two subforms on my form which are using same reference to the main
    > form.
    > The main form consists main record number (Purchase order number)
    > subform is a materials list for that purchase order.
    > second subform is in fact query which summarises how many of these materials
    > were delivered (basing on other form/table). So as result I'm getting a list
    > showing how many materials from PO were delivered. Now, I want to synchronise
    > these two subforms, so when I'm scrolling one, the other one follows. I found
    > one post in which there was a code for current event in both subforms:
    >
    > Private Sub Form_Current()
    >
    > Dim rs As Recordset
    >
    > If (Not IsNull(Me![ID])) And _
    > (Not IsNull(Parent.OtherSubFormControl.Form![ID])) And _
    > (Me![ID] <> Parent.OtherSubFormControl.Form![ID]) Then
    > Set rs = Parent.OtherSubFormControl.Form.RecordsetClone
    > rs.FindFirst "ID = " & Me![ID]
    > If Not rs.NoMatch Then
    > Parent.OtherSubFormControl.Form.Bookmark = rs.Bookmark
    > End If
    > End If
    >
    > End Sub
    >
    > Now, maybe it's correct, but could anyone explain what [ID] is.
    > Is it a lookup ID to the main form? If yes, my subform doesn't contain it.
    > I've made both subforms using wizard and they contain only data I've picked
    > for display on main form.
    > PLease help.
    >
     
  3. realspido

    realspido
    Expand Collapse
    Guest

    Correct me if I'm wrong: ID is a number in main form? Or subform? If subform,
    shall I create a relationship between both subforms keys? (I have only
    relationship to main table)

    Thanks

    "Wayne-I-M" wrote:

    > Hi
    >
    > Me.[ID] or Me![ID] refers to the field called ID. In your case you would
    > use
    > Me.[Purchase order number field name]
    >
    > Hope this helps
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "realspido" wrote:
    >
    > > Hi
    > > I have two subforms on my form which are using same reference to the main
    > > form.
    > > The main form consists main record number (Purchase order number)
    > > subform is a materials list for that purchase order.
    > > second subform is in fact query which summarises how many of these materials
    > > were delivered (basing on other form/table). So as result I'm getting a list
    > > showing how many materials from PO were delivered. Now, I want to synchronise
    > > these two subforms, so when I'm scrolling one, the other one follows. I found
    > > one post in which there was a code for current event in both subforms:
    > >
    > > Private Sub Form_Current()
    > >
    > > Dim rs As Recordset
    > >
    > > If (Not IsNull(Me![ID])) And _
    > > (Not IsNull(Parent.OtherSubFormControl.Form![ID])) And _
    > > (Me![ID] <> Parent.OtherSubFormControl.Form![ID]) Then
    > > Set rs = Parent.OtherSubFormControl.Form.RecordsetClone
    > > rs.FindFirst "ID = " & Me![ID]
    > > If Not rs.NoMatch Then
    > > Parent.OtherSubFormControl.Form.Bookmark = rs.Bookmark
    > > End If
    > > End If
    > >
    > > End Sub
    > >
    > > Now, maybe it's correct, but could anyone explain what [ID] is.
    > > Is it a lookup ID to the main form? If yes, my subform doesn't contain it.
    > > I've made both subforms using wizard and they contain only data I've picked
    > > for display on main form.
    > > PLease help.
    > >
     

Share This Page