I have a large userform which records various pieces of information about
projects. Each project has a number of uniyts on it, each of which can have
different parameters.

To stop the userform becoming too large with too many options on it, i
would like to be able to click a command button which would then direct the
selections to a new sheet. All the cell references would stay the same. In
short i am looking to 're-use' the userform.

The issue i have is that i set the control source within the properties
window for each textbox, dropdown etc, but to achieve what i want, i would
need them to all update at once with the new sheet name before the cell
reference.

Incidentally, is this something i should really be doing in Access?

Any help is greatly appreciated
--
Richard