Hi all,
Just a quick note to say I have only just started using VBA and have been thrown in the deep end a little..
OK, so what I need to do is create a lookup program that will take 3 different values from combo-boxes and combine them as the unitcode xx-yy-zzzzzz and find the items that correspond to the particular unitcode and display them and their details in a table (as seen in sheet 1, test database in sheet 2)
combobox2 values are dependant on combobox1 values (which I have coded) BUT, combobox1 values can be dependant on combobox2 values (e.g 01 in combobox2 can be selected by any of 02,12,52 or 62 in combobox1) so I want to get it so that by selecting a value in combobox2 I will get the values in combobox1 that correspond to it as well as the dependence I have already coded.
I'm also trying to get it so that selecting ?? in either box will display all the possibilities in the other combo box (and any values that are ?? will be assumed to be all possible values when searching the database for unitcodes)
I hope that makes some sense...
Thanks in advance!
Bryn
Bookmarks