In Microsoft Access (latest version), I have created a form, it has a large number of questions listed, user ticks the relevant questions which I want to form the basis of another form.
However, the only way I know is to put them all on another form and make them visible in VBA if it has been ticked on the previous form. However, this method looks very messy as there are large portions of the form blank. Is there a way to order them? So they appear one after the other without spaces(dynamically)?
Not sure if I am making sense but unsure how else to explain it.
Thanks in advance for any help offered.