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

Combobox dynamic load based on values in columns

P: 81
I have 2 tables, 1is a table of receipts with values stored under their proper category column (meat,200) and I have another table which gives an index to the category (3,meat). I am attempting to dynamically load a combobox with only the categories which contain a non-null or >0 value for a receipt number specified in a previous combobox.

The problem is that I am stuck on how to look up the data in the columns and then load the appropriate categories. Do I use an if statement which checks the values of each of the nine categories and lists only those with a positive integer >0 from the category table? If so how would I do this? vba programmatically or MS-Access sql?

Thanks in Advance
May 15 '09 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Hi. Not sure what it is you need help on, but the general technique of using one combo or listbox to filter another is covered in this Insight article:

Cascading Combo/Listboxes.

The article listed above is a good starting point about the general techniques of cascading combo boxes and formulating queries which feed those combos. If you need more specific help in formulating a query which excludes the null values you mention please post details of the tables, field names and types involved. If you could give us some examples of the data this would also help.

May 16 '09 #2

Post your reply

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