Click Subform Row To Change Record Fill on Main Form

[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

 

[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.

 

[Mike Painter]

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?

Subforms are (usually) based on a one to many relationship with the one side
being the header record in the main form. If you have established a master
child relationship then *all* the records in the subform must have the same
master record.

An invoice would have a header record with name, address etc and a subform
with related records showing the line items.

If you want to move to a new (master) record usually a combo or list box
would be used.

 

[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