Hey OBP - would you mind having a look at something for me please. As new and green to access as I am, so far I have been successful in getting most things to work on my project. I am however, having one problem in trying to populate a list box on the selection of another list box. I have read numerous and numerous posts, copied and pasted code etc, but nothing is working. So far I have Table 1 which contains fullname, building, position, ext and mobile.
Table2 contains building and fullname. Listbox101 is populated with building names from Table2. I am trying to populate another listbox with the names associated with the building they work in after that building in listbox101 is clicked. All I ever seem to achieve is all the names appearing in the second listbox already populated. Thanks in advance, and if you can't thats ok as well. I'd upload the file but it says its an invalid file - and to be sure you know, I have basically made this using the wizard - no code :-)