T
twen
Ok I have a form that has two list boxes side by side with Add and Remove
buttons in between where the list box on the left is people not members of a
group and the list box on the right is a list box of people who are members
of a group. You can select multiple people from each side to add to or remove
from the lookup table. When I add to the list though there are other values I
want to add to the lookup table so I built a pop-up form which allows the
user to select other properties to input into the table and take the Group ID
and Contact ID from the main form and pass them through an openargs
statement, but what I want to know how to do is when it is cycling through
the records in a For statement is how to pause the for statement while the
other form opens so that you can add multiple people at a time and each time
the form opens it will display the next selected item from the list.
Currently the pop-up form will open but the For statement in the main form
just runs its course and all it sends is the first record so when the user
clicks add it only adds the first item instead of each separate selected
item. Any idea on how to pause and go to the next record in a For statement?
buttons in between where the list box on the left is people not members of a
group and the list box on the right is a list box of people who are members
of a group. You can select multiple people from each side to add to or remove
from the lookup table. When I add to the list though there are other values I
want to add to the lookup table so I built a pop-up form which allows the
user to select other properties to input into the table and take the Group ID
and Contact ID from the main form and pass them through an openargs
statement, but what I want to know how to do is when it is cycling through
the records in a For statement is how to pause the for statement while the
other form opens so that you can add multiple people at a time and each time
the form opens it will display the next selected item from the list.
Currently the pop-up form will open but the For statement in the main form
just runs its course and all it sends is the first record so when the user
clicks add it only adds the first item instead of each separate selected
item. Any idea on how to pause and go to the next record in a For statement?