RE: Design/Logic Comments

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ajit (Ajit_at_discussions.microsoft.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 11:51:05 -0800

Thanks for your reply Ben.
The other state could be done the next day or what ever time. They don't
have to be one after the other. So i am looking something like...saving the
first state and doing the second at some other time.

"ben" wrote:

> if it is a userform, simply Hide it and do not unload it, this will keep
> the values exactly as they last appeard, and then on the userform.activate
> event delete the values you don't want there
> userform name = ok
>
> ok.hide
>
>
> "Ajit" wrote:
>
> > I have one template for each state. Each state has couple of forms to select
> > the values from (listboxes and option button selections). After user makes
> > all the selections, output is dumped into excel *** as required.
> >
> > What I want to achieve :
> > After doing one state, when user starts second state, I want to give the
> > ability to user to prefill the form controls with the values from the
> > previous completed state (with the ability to change the prefilled values).
> >
> > I am working on the design yet and would appreciate expert views on the
> > design/logic from the forum.
> >
> > --
> > Ajit

Quantcast