Cannot see all of subdatasheet on a nested subform

[jcfraun]

I have a main form with three subforms. On two of the subforms, I have nested subforms. All of the subforms are set to view as datasheets. When I open the subdatasheets, though, all of the data isn't visible and I have to scroll through it. Is there a way to make this subdatasheet always on top of the other windows?

 

[TheAceMan1]

How are ya jcfraun . . .

Have you considered using the [blue]Tab Control[/blue] Object? ... Its just the thing for saving screen realestate ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MajP]

Can you explain this better? You say you have two subforms that are set as data sheet, and each of these have nested subforms. That does not make sense because you can not nest continous forms or datasheets. So I am not picturing what you have or what you want.

 

[MajP]

Look at the Customer Orders subform in Northwind to see an example of synchronized continous subforms. Maybe synchronized continuous forms would work. I think maybe you could have multiple Tabs with a two subforms on each tab. The first subform on a tab is your main records the second one are the child records that would have appeared in a sub data sheet.

 

[TheAceMan1]

jcfraun . . .

In parallel with [blue]MajP[/blue], some assemblence of your [blue]table structure[/blue] would be a big help as well . . .

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jcfraun]

Thanks for the responses. I haven't used tabs before - I'll have to look into that.

As far as the nested forms go, though, they are synchronized subforms. The parent form is set to Single Form - this is where I select the category.

The first subform (child) is all attributes associated with the category. The second subform (child) is all products within that category with that attribute. The third subform (child) is all products in that category without that attribute. Then the second and third subforms each have subforms (grandchildren?) which just show information about the products - product name, etc. All of the children and grandchildren are set as Datasheet view. The grandchild form is only visible if you click on the plus sign next to the record in the child form.

Obviously, this is my own terminology. I'm still learning all the lingo. This is my very first database project (I've been using Excel extensively for years, but never Access - my projects got too big for Excel, so I'm jumping in to the database world.) Thanks for your patience.

 

[MajP]

I beleive your terminology is off a little and it caused me some confusion. I beleive you have subdatasheets on your subforms not nested forms. They are very different in capability and what you can do with them.

If I understand you correctly this would be my desingn.

1. Main form unbounded. Put a combobox on the main form with your categories. You can pick a category from the combo
2. Put a subform1 (attributes) on the main form as a datasheet or I would use a continous subform. If this is only for selection purposes I would just use another combo and make cascading combos. Pick a category from combo 1 then pick an attribut from combo 2.
3. Put a tab control with two pages "Products With Selected Attribute", "Products Without Selected Attribute". Put this underneath your continous subForm 1
4. Put two subforms on each tab page. So page 1 has subformRelatedProducts and below it you have continous subformProductInformation

Assuming you go with subform1 not a second combo

5. Subform control 1 is linked to combo1. Pick a category it controls the records in subform 1
6. SubformRelatedProducts, and subFormNonRelatedProducts are linked to subForm1 (attributes). Select an attribute and the subforms show related products on their respective tabs
7. The subformsRelatedProduct1 and subformRelatedProduct2 are linked to their respective parent subform on the pages. So if you select a related product it will show underneath the product information.

If in fact you want to see all of this information at once I would use a treeview. Then you can see

Category1
------Attribute1
---------------Related Products
-------------------------------Product 1
---------------------------------------- Product 1 Details
-------------------------------Product 2
---------------------------------------- Product 2 details
------Attribute2
---------------Related Products
-------------------------------Product 1
-------------------------------Product 2

 

[MajP]

Sorry This should read
7. The subformsRelatedProductInformation1 and subformRelatedProductInformation2 are linked to their respective parent subforms on the pages. So if you select a related product it will show underneath the product information

 

[jcfraun]

Thank you, MajP. It sounds like we're on the same page now. I will try that. I basically have it set up this way currently, just without the tabs. Only one error yet to resolve....

 

[MajP]

Now that I reread your post. maybe all you want to do is expand all of the subdatasheet records. The code is something like this.

Private Sub Form_Open(Cancel As Integer)
Me.Orders_subform.Form.SubdatasheetExpanded = True
End Sub

Or you can just set the subdatasheet expanded property to Yes by selecting "View", "Properties" in design view of the table.

 

[jcfraun]

MajP -

I really appreciate all the help. What I want is when I open a record in the subdatasheet, I want it to show the entire line of data. Right now, it cuts off at the physical end of the subform so that I have to scroll to the right to see both fields in the subdatasheet. The subform simply isn't wide enough, but I don't want to make it wider. Possibly my solution is to do something with a popup so that the subdatasheet data will popup on top of all the forms and subforms? It's not really all that important as the form is working.

Thanks!