Main form with two sub forms

  • Thread starter Thread starter GLT
  • Start date Start date
G

GLT

Hi,

I have a main form with a linked sub form which displays related records
when a record is selected on the main form.

Rather than use the record selectors at the bottom of the screen on the main
form to navigate records, I would like to create another sub form (#2) which
is unlinked, to the main form but contains a summary of all records on the
main form.

When a record is selected in Sub form # 2, I would like the main form to
jump to that record as well. If I link sub form #2, then only the current
record is displayed, not a complete list.

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.

Any assistance would be greatly appreciated..

Cheers,
GLT
 
hi,

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.
Click to expand...
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 <--
 
Back
Top