Programmatically Add TextBox And Label To User Form

[jo15765]

I have a combobox on a user form that holds a number value from 1 - 10. On the selected index changed of the combo-box I need to add a label and a text box directly under the text box and combo box above. So for example, if the number 2 was selected 2 rows with a label and a text box should be added.



How can this be achieved in Access 2013 (or if it's easier 2016 as I have that handy too) with VBA?

[ranman256]

Add the items needed In Design mode,
make them invisible.
when you need them,turn them on,
txtBox.visible=true

[jo15765]

Read the desired count from the combo-box and unhide that many text boxes?

[davegri]

Something like this.

Select Case combobox
    case 1
        txtbox1.visible = true
    case 2
        txtbox1.visible = true
        txtbox2.visible = true
    case 3
        txtbox1.visible = true
        txtbox2.visible = true
        txtbox3.visible = true
    ..... and so on       
End Select