I'm sure this is basic but I'm new so bear with me.
I have two list boxes of which I will populate the first list box with names and then will select names from the first list box to be moved to the second list box for additional processing.
The first list box I populate is based on criteria entered on an Access form. I tried doing a Load of the particular list box, but that was too early in the process as the fields on my Access form haven't been filled out yet which are used in the criteria to load the list box. If I populate my list box upon Enter or On Focus, it works great until I select the second, third etc person in which it re-executes the logic again to populate the list box and I get multiple sets of the same people in the list list box. What is the best way to load my list box so it will only do it once?
I have two list boxes of which I will populate the first list box with names and then will select names from the first list box to be moved to the second list box for additional processing.
The first list box I populate is based on criteria entered on an Access form. I tried doing a Load of the particular list box, but that was too early in the process as the fields on my Access form haven't been filled out yet which are used in the criteria to load the list box. If I populate my list box upon Enter or On Focus, it works great until I select the second, third etc person in which it re-executes the logic again to populate the list box and I get multiple sets of the same people in the list list box. What is the best way to load my list box so it will only do it once?