By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Having a Combo Box display part of a list based on a parameter

kcdoell
100+
P: 230
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.
Feb 8 '08 #1
Share this Question
Share on Google+
1 Reply


kcdoell
100+
P: 230
Thanks I found the answer at the following website:

http://www.fontstuff.com/access/acctut10pfv.htm

Keith.
Feb 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.