Multiple Instances of a Form

[Dave Ruhl]

In Access 2002 is it possible to open multiple instances
of the same form ? Thanks.

 

[Jeff Conrad]

Hi Dave,

See if this article helps:
ACC2000: How to Open Multiple Instances of a Form
http://support.microsoft.com/?id=210248

 

[Dave Ruhl]

Thanks Jeff! I was able to open additional instances of
the form. Now I just need to play around with it a bit
to get it to work the way I want. Thanks again...

Dave

 

[Douglas J. Steele]

Once you've instantiated the new instance of the form, using

Set frmX = New Form_Customers

you should be able to set a filter to it using something like

frmX.Filter = "Customer_Id = 1234"
frmX.FilterOn = True
frmX.setfocus

If Customer_Id is text, you need to include quotes:

frmX.Filter = "Customer_Id = '1234'"

Assuming you're going to use a variable, it'll be

frmX.Filter = "Customer_Id = " & lngCustomer

or

frmX.Filter = "Customer_Id = " & Chr$(34) & strCustomer & Chr$(34)

 

[Guest]

Thank you very much. That worked perfect. =)

Once you've instantiated the new instance of the form, using

Set frmX = New Form_Customers

you should be able to set a filter to it using something like

frmX.Filter = "Customer_Id = 1234"
frmX.FilterOn = True
frmX.setfocus

If Customer_Id is text, you need to include quotes:

frmX.Filter = "Customer_Id = '1234'"

Assuming you're going to use a variable, it'll be

frmX.Filter = "Customer_Id = " & lngCustomer

or

frmX.Filter = "Customer_Id = " & Chr$(34) & strCustomer & Chr$(34)

 

[Jeff Conrad]

Thanks Doug, I've been pretty busy today.