I want to have a userform where combobox2 "Description" is based on combobox1 "Funding". And combobox3 "Item" is based on combobox2 all in the SAME table (T_FUNDING).
This I have help previously to achieve with thanks to members here!
What I want do now is keep the above relationship between the comboboxes, but add an new relationship:
If "stock" is selected in combobox2, then I want combobox3 NOT to refer to T_FUNDING table, but refer to column 1 in T_Stock table. And the related code to be column 2 in T_Stock.
How do I do this?
Bookmarks