How to create a form with variable defined array and checkboxes

[Jeremy van Frank]

I have a list of people which can change depending on other factors (I
can already retreive this list) - what I want to do is create a popup
(userform) that lists the people and beside each name is a check box.

I can then select one or more of the people (checkboxes) and then
click OK when then sends the Yes values to another subroutine.

Is this possible and if so sample code would be appreciated or at
least the overall structure.

Thanks!

 

[Hollis D. Paul]

Is this possible and if so sample code would be appreciated or at
least the overall structure.

Look for sample code on www.slipstick.com or on
http://www.outlookexchange.com/Articles/home/outlookcodeexample.asp

One of the styles of the list includes checkboxes, but you will
probably have to use an unbound listbox, and then use the click_event
handler to move the checked items to fields and an array, and pass the
array to the other subroutine.

I'm not sure that you will be able to use a popup screen. It might
just be better to show and hide a back tab of the form to display the
list.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA