Expandable/Collapsible Form Option

[neash83]

Hello,

I have a form that I want to expand to show more fields depending on whether a user decides to or not.

Basically there will be 5 fields that a user always completes for this form, however depending on whether they answer yes or no on the final field I want it to expand the form and have some further fields that need completing.

If they select yes it should expand, if they select no then the form is complete.

What are some possible ways of achieving this?

Thanks

 

[bob fitz]

You could have the second set of questions hidden and have some code in the After Update event of the last question of the first set that makes the other questions visible.
Or you could have a tab control on the form with each set of questions on a separate tab page.

 

[Simon_MT]

Alternatively,

Create a dialog form with the additional fields that reflects information on the original form.

Simon

 

[vbaInet]

If you know what you're doing then all of this fancy footwork is fine, but to keep things simple I would go with Simon MT's and bob fitz's ideas.