[AccessD] simple questions: combo box help

Does the table your dependent list is pulled from have some field that links
it to the policy holder?  If it does, then just use a reference to a control
on the main form that holds that connecting information in the query for the
dependent combobox.  If not, then you have a big problem.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jamie Kriegel
Sent: Thursday, May 29, 2003 2:02 AM
To: Accessd at Databaseadvisors.Com
Subject: [AccessD] simple questions: combo box help


Hi Everyone,

I have what I hope is a very simple question.  I have a form with a
subreport (actually two subreports).  This form is used in an insurance
database.  The first main form lists policy holder info, subform 1 lists all
policies that this particular customer has (auto, life, home, etc.) and
subform 2 list all dependents on whatever policy is in subform 1 (e.g.
subform 1 lists auto policy and subform 2 shows that the policy holder's
wife and son are also on this policy.)  Anyway, on subform 2 I have a combo
box where I want to pick the dependent's name (if I'm adding a dependent to
a policy.)  My only problem is, the combo box lists EVERY dependent in my
database.  How do I filter this combo box to only show the policy holder's
dependents?

Any help would be GREATLY appreciated!

Thanks,
Jamie

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com