Using a subform twice on the same form

[dch3]

I need to know if its possible to use the same subForm twice on the same
parent form. Does Access create two separate instances and view each as
separate controls? I'm building a wizard were unassigned child records can be
assigned to a parent or removed. The primary difference between the two is
that they'll have different record sources.

 

[Pete D.]

Different record sources or different records. Makes a Differents

 

[dch3]

A different record source which will thus result in different records.

 

[Pete D.]

Well, your over my head but... how does access know the difference between
the two identical forms even if they have different sources. I would think
that you would have duplicate control errors. Probally would be much easier
to just use identical forms with different names.

 

[dch3]

Still waiting for a response....

Well, your over my head but... how does access know the difference between
the two identical forms even if they have different sources. I would think
that you would have duplicate control errors. Probally would be much easier
to just use identical forms with different names.

 

[Rick Brandt]

Still waiting for a response....

You're asking if it's possible. Why don't you try it and see what happens?
It will either work or it won't.

 

[John Spencer]

I don't know the answer to your question, but I don't think it would be too
difficult to set up a test case and see if it works or not. It should take
you less than 30 minutes to do a simple test case.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Pete D.]

That was nice, yes it is possible, one Access is powerful and you can reach
in and touch it. When you get it done please post your code so others can
use it. Might check out some of http://www.lebans.com/Form.htm solutions
which are super pratical/wanted ideas that he took the time to make happen.
When programing in windows/access ask your self, can I or is it worth the
time. It's a computer, yes you can, but I would like to make it happen in
my lifetime!