John:

Don't know if this helps but this is the (simple) method I use for 
scrolling controls on a form.

Private Sub VScroll1_Change()
  myControlArry.Top = 0 - VScroll1.Value
End Sub

This should make the control(array) go off the top (or bottom) of the 
screen and seem like the form is scrolling.

In some cases, I have a check in the code to not change command buttons, 
but change ".Top" of everything else. This should also work the same for a 
Horizontal Scroll bar - only replace ".Top" with ".Left"

I would love to hear any other srcolling suggestions...

P.S. I definately agree with Janeks in that a FlexGrid would be a much 
more efficient way to add the data to your form.


Kevin



> I have a form that has a command button and a frame.  When the command
button is clicked, it retrieves records from a database, creates a
control array and adds the items of the control array to the frame.  I
resize the frame as the items in the control array are being added.  The
problem I am running into is that after about 10 items, the frame size
has expanded past the bottom of the screen.  I can't really see any way
to link the VScrollBar control to anything and the form has no scroll
bar setting. 

Here is my question:  Can I "bind" the scroll bar to the frame or form?
If I can't "bind" it (for lack of a better word), will I just have to
manually code the events for the scroll bar?  Hopefully there is a
better way to scroll up and down in a frame or on a form.

Thanks in advance,

John