Where are my forms

[DevalilaJohn]

Please ignore the immediately preceding post.

I have a process that imports data. That works fine, but it can take long
enough for the user to wonder if anything is happening. I built a form to
give the user status on the process and went to open it via

load <formname>
<formname>.show

This fails with my formname being flagged as an undefined variable. So I
decided to look a little deeper. I went to the immediate window at a
breakpoint and asked for
?forms.count
the result was 0.

I've been working with these things for a while now and have no idea why I'm
suddenly "losing" my forms collection. Any thought would be greatly
appreciated.

John

 

[Dirk Goldgar]

Please ignore the immediately preceding post.

I have a process that imports data. That works fine, but it can take
long enough for the user to wonder if anything is happening. I built
a form to give the user status on the process and went to open it via

load <formname>
<formname>.show

This fails with my formname being flagged as an undefined variable.
So I decided to look a little deeper. I went to the immediate window
at a breakpoint and asked for
?forms.count
the result was 0.

I've been working with these things for a while now and have no idea
why I'm suddenly "losing" my forms collection. Any thought would be
greatly appreciated.

John

You're talking about a Microsoft Access application, not a VB app?
Access forms don't have Load and Show methods. You open a form with

DoCmd.OpenForm "FormName"

 

[Duane Hookom]

You seem to be mixing development environments. "Load" and "Show" are used
in VB, not Access (at least not that I am aware). The forms collection would
return open forms. To display a form, use
DoCmd.OpenForm "formname"

 

[DevalilaJohn]

Thanks for the replies. I was having one of those days. Everything is
working fine now.