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