Click Subform Row To Change Record Fill on Main Form

  • Thread starter Shon Baker via AccessMonster.com
  • Start date
S

Shon Baker via AccessMonster.com

I have a main form with a subform(datasheet). The main form shows header
type fields(candidate, branch, address, etc) and the subform shows certain
other fields.

I need to be able to click or double click on a row in the "subform" to
change corresponding header fields on the main form.

Right now, if I use the navigation button on the subform it moves to each
row, but does not change the main form records. The main form keeps the
record fields for the very first record. If I click on the navigation
button for the main form it changes the header records but does not change
the records in the subform.

How can I click on a row in the "subform" and make the header records in
the mainform change too reflect the new record "row" clicked on the subform?


Thanks,
Shon Baker
 
D

Dan Artuso

Hi,
Are you linking fields between the forms? Usually there's a linking field between a main and subform
so that when you navigate records on the main form, the subform displays the appropriate subset.
If you look on the properties sheet of the subform control (on the Data tab) you will see the link master and child fields.
Set these accordingly and it should work.
 
S

Shon Baker via AccessMonster.com

Oh. I'm using the subform to "list ALL" the records for a client. And when
I click on the row of the subform, I wanted the header to change to reflect
that record. The subform lists only a "subset" of the record. The record
is sooo long I broke it up with a header to show more details of the
record. Sort-of a look at the entire record at one glance, on one page,
without scrolling.

Given this scenario, is it still possible using a subform? Also, this is
an edit page, so I tried to use a List but it's not updatable.

Thanks,
Shon
 
Top