I want to use queries in options list, say I have a query which has itemname, itemid, and catid (foreign key). Now I want to fill my list box with the value I defined for foreign key in this case catid. I have a number of list boxes related to the same query which brought the result for all catagories, but I want every list should have only the values related to that list box. Is here any sql/vb geek to solve my problem?