maximun of 20 comboxes will appear based on assign number

[fucell26]

im trying to create a training matrix in which i need a form that if I put or assign maximun of 20 attendees then 20 comboxes will appear in form.



for example,

i enter in textbox1 6 or 15 depends but max is 20

then if hit enter comboxes will appear but quantity will based on value that i enter in textbox1

anyone knows how to do that or any much easier idea ?

thank you in advance.

[JeffChr]

i would put the combo boxes on the form and hide them initially. then unhide them using vba based on textbox1 input.

[fucell26]

i would put the combo boxes on the form and hide them initially. then unhide them using vba based on textbox1 input.

so you mean ill put all 20 combo box in form and hide them. but what if he the user put only 10 so the other 10 will not appear ? thats the problem i dont know how to do that. btw thanks for your idea.

[ranman256]

If you use continuous forms, put a combo box in it, add 20 records, you'll get 20 boxes.

[fucell26]

i see ill try it. and i reply once ive done. thanks guys.