Combo boxes

[ehale]

Hello. I have a form based on a query that includes two
fields: Insured and Policy #. I want a user to be able to
get the desired record by selecting either the Policy # or
the Insured via combo boxes that look up the data from the
query. But either combo box has to update with
corresponding data, so user can see what policy # goes
with what Insured, etc. Anyone know how to accomplish
this? Any help is appreciated. Thanks!

 

[John Vinson]

Hello. I have a form based on a query that includes two
fields: Insured and Policy #. I want a user to be able to
get the desired record by selecting either the Policy # or
the Insured via combo boxes that look up the data from the
query. But either combo box has to update with
corresponding data, so user can see what policy # goes
with what Insured, etc. Anyone know how to accomplish
this? Any help is appreciated. Thanks!

What's the structure of the table? Can an Insured have more than one
Policy, or can a policy cover more than one Insured? You'll probably
need TWO combo boxes, and they will need to include both fields if so.