Modifying form design in VBA

[aytee111]

I want to be able to add controls to a form/modify the form design after certain user-entered values. Does anyone know of a link where I can read up on how to do this?

[ssanfu]

I want to be able to add controls to a form/modify the form design after certain user-entered values. Does anyone know of a link where I can read up on how to do this?

I think this is a bad thing to do... for many reasons

Having said that, open any code module. In the menu bar, click on HELP. In (#1) Enter Keywords, type for "CreateControl" . Look for "CreateControl, CreateReportControl Methods" in the topic area (#3).

[aytee111]

Thanks, I'll go there.

I wanted to add additional page control tabs if the user selected additional items. Maybe you're right, I should come up with a different design.

[ssanfu]

Thanks, I'll go there.

I wanted to add additional page control tabs if the user selected additional items. Maybe you're right, I should come up with a different design.

I would have the controls already created, then hide/show controls as necessary..... Just my 2 cents

[aytee111]

The trouble is that there is no sequence to their adding - they could select apples, then oranges, or peaches then pears then bananas! I don't even know how many they will choose. Anyway, as you said, probably a bad way of setting it up.

Also, this will be a runtime version, I don't even know if I can make changes to a runtime database. As you can see, first time I am doing something like this.