Hello everyone. I have some confusion on passing variables. I need to store variables from a form and then retrieve them later. What I have is three form that a user fills out and presses a next button to go to the next one. So the idea is to have the values from the text boxes stored and when the final form is finished retrieve all the variables for an SQL command.

Any ideas will be greatly appreciated.

Thanks,
Jesse

__________________
Thanks,
Jesse

Why don't you just use a tab control to put all the info instead of jumping from one form to another?

Sal

That is how I had originally built it but it was requested that the fields be seperated in groups in seperate forms and to guide the users navigation with a next button. All of the fields from the seperate form need to be added to a single table at the final step.

Thanks,
Jesse

You can either create global variables in a module (I do not like those) or open a hidden form and set values on it as you go along.




Sal

Thanks, I'll try that.

Thanks,
Jesse