[AccessD] simple questions: combo box help

Jamie Kriegel jamie at kriegelpcsolutions.com
Thu May 29 01:01:37 CDT 2003


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



More information about the AccessD mailing list