B
ByB
Hello,
I work in a program in Access VBA and SQL Server database.
I use a form named F_FirstForm and another named F_SecondForm.
The first form I display is the F_FirstForm.
I make the form close (by using "Unload Me"), and then, according to a
specific value, the closing form will call the F_SecondForm or the
F_FirstForm again, with different values in display. Then, the same
process will repeat itself when close the now form displayed and so on.
But when I try that, if the F_FirstForm call the F_SecondForm,
everything is ok. But if the F_FirstForm has to call again the
F_FirstForm when closing, the F_FirstForm does not open.
It looks like if all instances of F_FirstForm were in fact the same
instance.
So how can I manage to make F_FirstForm close and open F_FirstForm
while closing, with different data ?
Thank you for any hint.
--
Les gens de la maison Dubois, à Bone, scient
Dans la froide saison, du bois à bon escient.
(C'est vraiment triste, pour deux vers, d'avoir les vingt-deux
dernières lettres pareilles, et de ne pas arriver à rimer.) (Alphonse
Allais)
I work in a program in Access VBA and SQL Server database.
I use a form named F_FirstForm and another named F_SecondForm.
The first form I display is the F_FirstForm.
I make the form close (by using "Unload Me"), and then, according to a
specific value, the closing form will call the F_SecondForm or the
F_FirstForm again, with different values in display. Then, the same
process will repeat itself when close the now form displayed and so on.
But when I try that, if the F_FirstForm call the F_SecondForm,
everything is ok. But if the F_FirstForm has to call again the
F_FirstForm when closing, the F_FirstForm does not open.
It looks like if all instances of F_FirstForm were in fact the same
instance.
So how can I manage to make F_FirstForm close and open F_FirstForm
while closing, with different data ?
Thank you for any hint.
--
Les gens de la maison Dubois, à Bone, scient
Dans la froide saison, du bois à bon escient.
(C'est vraiment triste, pour deux vers, d'avoir les vingt-deux
dernières lettres pareilles, et de ne pas arriver à rimer.) (Alphonse
Allais)