How can I open a SubForm without Subform Expanded

[djclinton15]

Hi, when I open a certain Form which has a Subform (in Datasheet) the dropdown (Subform) are automatically expanded. I want this Form to open with all collapsed (as I have in other Forms/Subforms). Is there a trick in the Properties Settings to change this Form/Subform to open with the Subform collapsed? I hope that I'm making some sense here?




I would greatly appreciate any suggestions. Thanks in advanced!

[June7]

Is the main form opened in Datasheet view?

[CJ_London]

if you have it working in other forms subforms - what is different about this one?

[djclinton15]

June7: Yes

Ajax: I don't know. That's why I posted my thread.

[CJ_London]

Well, not sure how we can know either - suggest you compare the properties of your 'faulty' form with one that works on a property by property basis.

Regards your response to June - datasheets can't have subforms so perhaps that is your problem

[djclinton15]

Wait, a Datasheet Form can have subforms.

[djclinton15]

Main Form,under Format Properties 'Subdatasheet Expanded'needs to "No." I somehow had it on '"Yes" but when I changed it to'No" it resolved my issue. Thanks!be

[CJ_London]

Wait, a Datasheet Form can have subforms.

No, they can't. What you are talking about is a subdatasheet which is something else. but glad you have resolved your problem

[djclinton15]

Ajax, you're absolutely right! I did mean a Subdatasheet within a Datasheet. Sorry.