I have create multiple user forms to accept variables for editing and process. 2 problems that I don't know how to handle:

1. One of forms I have is to capture 5 sets of responses that users reply. Each set is consisted of 4 questions. Instead of coding individual combobox1, combox2, textbox1, textbox2, ...etc, which is lengthy, and looks redundant. Is there a way that I can cut down the code so that I can utilize the same code and apply for each set of questions? Since functionality for each set of questions is the same.

2 Once I capture all the variables from the user, how do I make the VBA go back to the main module which starts out the first form?

Any assistance, greatly appreciate.

Kathy

1. Difficult to answer without knowing the questions. However I guess it would be easy to use a single text box and refresh it with the new question once one has been answered. An example of this would be a series of Message boxes ...
2. Hide or Unload the form.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.