View Single Post
  #1  
Old January 26th, 2010, 12:15 PM posted to microsoft.public.access.forms
GLT
external usenet poster
 
Posts: 154
Default Main form with two sub forms

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