combo box problem

[Johnny0123]

hi,

i need a combo box that updates the same form that it is on and updates if another field is changed. For example: ProductID is PK of a table and FamilyTitle is just a field in another table. So many products(ProductID) can have the same FamilyTitle but a product can only have one FamilyTitle. my problem is that i get many of the same FamilyTitle replacated in my combo box. I only want to see the FamilyTitle once in the combo box and then go to one of the records and then only show records that are from that FamilyTitle. And like I said it has to change / update when the ProductID field is changed.

Someone PLEASE HELP !!!!
Thank you in advance.

-John

 

[lespaul]

if you add DISTINCT to the query that is the source for your FamilyTitle you will get only one instance of each FamilyTitle.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual