Pop-up subforms

[quicksilver1024]

Hi,

I am trying to create a form that has a subform and a subform of a subform
So something like this:

Form
-subform1
-subform2

To make things even more complicated, I wish to create a series of buttons on the form that will launch a pop-up window containing the subform. The reason for this is that subform1 is to house different categories. Subform2 will then house the details for those categories. Of course all of this will share a common set of data (time, names etc..) with the Form. The way to achieve this is by using subforms (I believe...).

Can anyone please point me to a tutorial or a set of instructions on how I can set this up?

THANKS IN ADVANCE!
Peter

 

[ajetrumpet]

I wish to create a series of buttons on the form that will launch a pop-up window containing the subform.

Peter,

Subforms are forms too, no matter how far down they are nested. How about a line of command buttons on the main form that open each subform when clicked??
Then you could have other buttons on each subform you open that open the next form that is nested (from your "structure" jpeg...)

 

[quicksilver1024]

Your absolutely right, but the issue then would be attaching the Common Data with the subforms.

Will Access know this new pop-up is actually a subform? I know you can easily create buttons that would launch a new form, but how do I do the same for subforms?

 

[ajetrumpet]

subform1 is to house different categories. Subform2 will then house the details for those categories. Of course all of this will share a common set of data (time, names etc..) with the Form

Ok, I think I know what you need to do...from this comment of yours....

First of all, take a look at the screenshots from this link...http://ocw.mit.edu/NR/rdonlyres/Sloan-School-of-Management/15-564Spring2003/98C2F4A8-AF8F-4A1D-8362-C6EBF2B857FD/0/ms_access_forms.pdf

So, you probably want to create a series of subforms from your main form like this...
1) Main Form = some data from one or more tables.
2) SubForm1 = Create from a query that includes data from the categories table as well as your common data from whatever table that comes from (your Main Form underlying table)
To create a query that holds all this data from tables, use the UNION function...

SELECT [common data table or main form table].[relevant fields] UNION
SELECT * 
FROM [categories table]

Use the recordset from this query as the source of your subform(specifiy this in the subform wizard); for this example it would be your categories subform . I hope this is leading you in the right direction....

 

[quicksilver1024]

I have found a better way to do this by toggles!

I have made it so that the toggle buttons would change the visibilities of the subforms. But as usual, I am having trouble.

This is my thread regarding the issue:
http://www.access-programmers.co.uk/forums/showthread.php?p=611820#post611820


Thanks ajetrumpet for all your help.