Having a Combo Box display part of a list based on a parameter
Hello:
I have a table called "Products". In there are two fields; "Product Name" & "Product Category". I have about 24 products but only 3 product categories (for example Product Category A, B, or C).
In my main input table I have a combobox called "cobProduct " that is pointing to my product table. Currently it is displaying all 24 products. I want to limit that list based on another field I have on my form called "Working Region". That is to say if they get to my main input table and they have indicated that they are from the "Atlanta" working region then my "cobProduct " would only display the product names that are tied to Product Category "A".
Is there a VBA code that I can use that would filter this list? I am thinking that I maybe able to use the Me.filter = code but I not too sure in what way.
Thanks,
Keith.
I have a table called "Products". In there are two fields; "Product Name" & "Product Category". I have about 24 products but only 3 product categories (for example Product Category A, B, or C).
In my main input table I have a combobox called "cobProduct " that is pointing to my product table. Currently it is displaying all 24 products. I want to limit that list based on another field I have on my form called "Working Region". That is to say if they get to my main input table and they have indicated that they are from the "Atlanta" working region then my "cobProduct " would only display the product names that are tied to Product Category "A".
Is there a VBA code that I can use that would filter this list? I am thinking that I maybe able to use the Me.filter = code but I not too sure in what way.
Thanks,
Keith.
Comment