Excellent code which I am trying to use although I am still very much a VBA beginner. I have the following problem:
When I first open the frmMenu no items show in in the listbox but if I edit the form design (even if I don't actually change anything) and then reshow the form the list box is populated?? If I close the form and reopen it the list box is empty again.
This happens everytime even if I shut the database down and reopen it - do you have any idea what might be happening?