Variables Getting Reset After Displaying Form from another Form

Posted on 2003-12-05
Last Modified: 2010-05-01
Situation: I have a main form, a menu option displays a second form.  2nd form contains a listbox of items, selecting an item from the listbox allows a button to be pressed which displays a 3rd form.  Upon closing the 3rd form the focus is returned to the 2nd form.  

Everything works fine when you've selected 1 item from the listbox, but on the second item (no matter which item in the list that may be), by display/unloading the 3rd form variables held in the 2nd form are reset, i.e. a disconnected recordset I hold from having say 10 items suddenly has 0.

I initially thought it was maybe because I was displaying both forms 2 and 3 as modal, but I've tried it with modeless and the same thing happens.  I'm confused why values held in the 2nd form should be effected by another form, in addition not all variables are reset making it even more confusing, any help/suggestions would be great.

Running VB6 SP5 on Windows 2000 Pro


Question by:JEGBIE2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +3

Expert Comment

ID: 9882293
Have you made the variables global?
Add a module to your project and declare the variables in the module using
Public Var1 As String
LVL 48

Expert Comment

ID: 9882316
you should make a Property Get Set in  a Module

Private m_form2Vars as whatever

Public Property form2Vars() As Integer
            form2Vars = m_form2Vars
        End Get
        Set(ByVal Value As Integer)
            m_form2Vars  = Value
        End Set
   End Property

And you can set or get the value

form2Vars =  

Author Comment

ID: 9882375
Thanks, while I accept what you propose will work, what I still don't understand is why the private variables on the 2nd form get reset at all.  Form 2 is basically an object, by displaying a 3rd modal form you are not unloading the 2nd form or reinitialising it, it should therefore retain the same state+values it had before you displayed the 3rd form when you unload the 3rd form, if it didn't it would make displaying more than 1 form at a time useless.

Also the fact it does retain values the first time but then loses them the 2nd time makes me think there's something else causing the problem.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 26

Expert Comment

ID: 9882405
Is any reason you unload the form2 and restart?

LVL 48

Expert Comment

ID: 9882409
The Form in .NET is a Class when you Load it it just makes an Instance not the actual Form. Soin essence the data is lost
LVL 26

Expert Comment

ID: 9882421
I meant you may unload the form2 and restart in your code?

Show us some code

You can debug from debug menu, add watch with your variable name and

select break in value change on watch type

Accepted Solution

PBuck earned 250 total points
ID: 9883403
Just out of curiousity, are you performing init or load procedures/functions from your Form_Activate routine on your Form2 ?

If so, that would possibly explain why when closing form3 your vars get dumped or reset.  Obviously, the form_activate gets called when form3 is unloaded whether it is modal or not.

Expert Comment

ID: 9883583

Are you just using to load the form or are you creating an object of Form2 and displaying that.

Author Comment

ID: 9902965
I think I was having one of those working too long and hard on a tight deadlined project and I needed someone to state the obvious!  The problem was there was code in the form activate event which did reset variables, however, I had these covered by a flag which is why I couldn't understand it, but it appears due to a mistake on my part this flag was reset at a point in error so after the first time the form activate code was run, DOH DOH DOH!  Thanks everybody who commented, I'm off to raid the fridge for a forbidden donut :)

Expert Comment

ID: 9904583
LOL.  Glad it was something simple - thanks for grade.

See ya around more on EE!

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question