default field in subform from main form

[JohnE]

I have a main form that has a tab control on it. The first tab is the main
form information while the subsequent tabs are subforms. There is a subform
(continuous) that has a field (drop list) that should be displaying (as
default) the selection made from a drop list on the main form (the first
tab). But it is not and it is becoming painful for the users that need to
enter the subform info many times. I am at a loss at to the best way/method
to make this process work? So I seek the help and wisdom of the group.

Thanks... John

 

[Al Campagna]

JohnE,
We could use more specific information as to your main form relationship
to your subform records, and why you are trying to capture the main form
value.
Given a control on the main form called [MainValue]...
Would multiple subform records associated to that main form, have
different [MainValue] values?
If so, then that value/field should probably be in the subform table,
rather than the main table.

But... going with what we have now... and assuming that a signle
[MainValue] is refers to ALL the related subform records...
Since the subform records are related to the main form by some
Parent/Child realtionship, then copying a main form value to each subform
record should not be necessary. So, there should be no need to "capture"
that value in your related subforms
In any subsequent form, query, or report, the subform record can be
re-related to the main form table, and display that related main form value.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."