Combobox dynamic load based on values in columns

[Cintury]

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 programmaticall y or MS-Access sql?

Thanks in Advance

[Stewart Ross]

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.

-Stewart