opening multiple instances of the same form?

[dean]

Can anyone tell me if it is possible to open more than one
instance of a form (showing different records).

For example, given a database that stored details of
projects and sub-projects, you may have the following
tables and fields:

projects:
projectId
project-name
project-description

sub-projects
projectId
sub-projectid

The same information is stored for a project and a sub-
project.

Now, the form that shows a projects details, say
frmProject, would include a sub-form, say frmSubProjects,
which would list the current project's sub-projects.

It would be nice if, when a user double-clicked on a
project's sub-project, Access could open up another
separate instance of the frmProject form, showing details
of the selected sub-project.

Is this possible? I don't think so, as Access (97) seems
to just update the existing instance of the frmProject
with the selected sub-project - not the desired effect.

Hope someone can answer this for me,

Thanks,

Dan.

 

[Van T. Dinh]

I am not sure how you handle 2 different Tables (personally, I would
probably use a self-joined Table for both Project and SubProject) but you
certainly can open more than 1 instance of the Form.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=210248

 

[dan]

simple, when you know how.

thanks.

-----Original Message-----
I am not sure how you handle 2 different Tables (personally, I would
probably use a self-joined Table for both Project and SubProject) but you
certainly can open more than 1 instance of the Form.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=210248

--
HTH
Van T. Dinh
MVP (Access)






.