Adding dynamic controls to Access form

[sumi]

I've an Access form with a fixed number of combo boxes,
which are part of a control array. I use this control
array to trap the events like 'KeyDown' and 'Click'. I
want to add more combo boxes dymanically to the form when
the user clicks "New" button in the form. Is it possible
to add controls to a control array dynamically?? How's
this done??

 

[Paul Overway]

There are no control arrays in Access, and you cannot add controls to a form
in an MDE database. You CAN add controls to a form using CreateControl.
However, the form must be in design view. So, unless you are designing a
wizard or don't mind confusing users, this has little practical value.

 

[Albert D. Kallal]

You don't have control arrays in ms-access. However, you can certainly use a
continues form, and have the control "repeat" over and over.

The following screen shots will give you some ideas:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

You look further in the above, I do have some examples where the combo box
repeats, and it is a very good substitute for control arrays as compared to
VB.