A
Andy
I have a simple database with 2 tables. [Policy] table contains policy
numbers, policy descriptions, and a few other items. [Tracking]
contains policy numbers that are tied to the [Policy] table via the
lookup wizard function. The [Tracking] table is used to track the
update process when a policy is being reviewed.
I have a form based on the [Tracking] table for data entry/end user
input. The user has the drop down box in the [PolicyNbr] field, which
allows them to select the [PolicyNbr] and [PolicyDesc]. Once this is
selected, I have a subform which 'pops up' and displays the other
information from the [Policy] table, connected via child/master
relationship.
Problem: when the end user selects the [PolicyNbr], the [PolicyDesc]
is not maintained in the form. Therefore when someone does a search,
they cannot search by [PolicyDesc]. The sub-form is all locked up for
2 reasons. 1) so they can't screw up the data, and 2) so they don't
realize it's a subform (I have taken all the controls off).
I have tried various ways of getting this to work, and have run out of
thoughts on the subject. I still consider myself a newbie, so if
anyone has a suggestion as to what I need to do, or a better set up,
please be descriptive. Thank you very much for your help.
numbers, policy descriptions, and a few other items. [Tracking]
contains policy numbers that are tied to the [Policy] table via the
lookup wizard function. The [Tracking] table is used to track the
update process when a policy is being reviewed.
I have a form based on the [Tracking] table for data entry/end user
input. The user has the drop down box in the [PolicyNbr] field, which
allows them to select the [PolicyNbr] and [PolicyDesc]. Once this is
selected, I have a subform which 'pops up' and displays the other
information from the [Policy] table, connected via child/master
relationship.
Problem: when the end user selects the [PolicyNbr], the [PolicyDesc]
is not maintained in the form. Therefore when someone does a search,
they cannot search by [PolicyDesc]. The sub-form is all locked up for
2 reasons. 1) so they can't screw up the data, and 2) so they don't
realize it's a subform (I have taken all the controls off).
I have tried various ways of getting this to work, and have run out of
thoughts on the subject. I still consider myself a newbie, so if
anyone has a suggestion as to what I need to do, or a better set up,
please be descriptive. Thank you very much for your help.