declaring variables as form types

G

Guest

I may be imagining it, but I recall that in Access 2000 declaring a variable
as a form type (Dim frm as New Form_Widgets) did not result in the form being
added to the Application.Forms collection, but now it does. Also, executing
the code "Set frm = New Form_Widgets" multiple times now results in multipe
copies of Widgets being opened in the Application.Forms collection and the
variable frm being set to the last instance of Widgets that was opened, which
also was not true in Access 2000. Can anybody either confirm this or set me
straight?
 
D

Douglas J. Steele

I'd be very surprised if that were the case, since I just tested with Access
97, and the form is definitely added to the Forms collection.

If your intent is to manage multiple instances, take a look at what Allen
Browne has at http://www.allenbrowne.com/ser-35.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to list the names of forms and reports of an .mdb database by VBA 2
Help with new form instance coding please. 3
Updating text objects on the form that opened the current form 4
declaring a variable as "Index" turned out into "index" 2
Pass Control as Argument 3
Array of Form controls 1
Module Data Storage 2
Declaring Public Variables 3

Top