Think I have a tough one here for you

[RangerTen]

Need Some Help on this one

I have a form that I want to have open, because the user needs to work with it. However, is it possible for me to have 6 different instances of the same form displaying 6 separate records from the same table. I think vb.net handles this by default, but how do you do this in vba?? The user of my program has to be able to see at 6 records at the same time (any 6 the user chooses, not just the last 6).

What kind of problems would this create for me. I want to be sure that only one instance of one record can be open at any one time

I tried the ...
Dim newform as New Form1

Didn't work

anyone know the syntax (if there is any).

Thanks very much.

Pete

 

[RangerTen]

son of a gun

Here is the error message i get

Error:
Compile error
User Defined type not defined

I put this statement in a standard module

Public newfrm1 As New frmForm1

I then have a command button on a separate form that has attempts to open the new instance....don't know how to go from here

How do I define the new form?