Opening and Closing Forms

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi,

i have three forms and would like to use the Next / Back buttons to open
one form and close the old form ... and in reverse order.

i need to find which is the active form so i can close it.

thanks.
 
i have a previous / next on every form.

if there is also a way of using a global variable to track an ID number
that would help also.

thx
 
Josef,

You have several options:

1. You could simply have a Public string array (declared in some module) to
hold the names of each form in the sequence, and as the Open event fires for
each form, custom code can add the form's name to the list, plus the name of
the *next* form in the sequence.

2. You could add an array to each form (or indeed just two variables,
strPreviousForm and strNextForm), using the form's OpenArgs property to
collect the name of the form that opened it. Just in case you didn't know,
the DoCmd.OpenForm method has an OpenArgs argument.

3. You could implement a Stack, which is a collection class. It too, would
be declared public in some module. This option, although much more flexible,
is also more complex. If you specifically want to go down that track, I can
provide you with the code to implement it.

<<a way of using a global variable to track an ID number>>
Of course. Just declare a Public variable somewhere.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top