hi,

On 26.01.2010 13:15, GLT wrote:
In essence what I am trying to achieve is an extra sub form that give a list
of records that the main form contains, and when a record is selected on the
sub form # 2 it is reflected in the main form and sub form # 1.
Synchronizing multiple forms can be painful. In your case I would
consider using one synchronization method in the main form which is
called from the sub-forms when necessary. E.g.

Main form:

Public Sub Synchronize()

'your synchronization code here

End Sub

Private Sub Form_Current()

Synchronize

End Sub

Sub form 1/2:

Private Sub Form_Current()

On Local Error Resume Next

Me.Parent.Form.Synchronize

End Sub




mfG
-- stefan --