General Form Building process in VBA

[mrlemmer11]

Hello,

This is mainly and general information/reference seeking question.

What is the standard for good form building regarding toggle'ing visibilities and what not. What I mean is if I have 10 labels, with 10 text box's for user input and 10 submit button and I want the only the first group (label, box, button) to show until the user enters something and clicks submit, and upon submission, the second group shows. This repeats until the last group with the final submit button... My question is this, should I build the form with all 10 groups listed and 9 of the 10 groups not visible.... or should I build it so that when the user submits group1 the code builds and adds the second groups etc...

Like I said, I can get it done with having everything built upon form launch, just trying to figure out good theory on this. Thanks everyone.

 

[ChrisM]

I would say create a 10 and hide/unhide as necessary. That's much easier than coding them on the fly.

but, I'd also ask, do you need 10 different versions? Can you just re-purpose one set 10 different ways? For the first round, you set Label.Caption = "Question X" and then for the second round you reset the same caption to "Question Y", etc.