Me.SubdatasheetExpanded = True 'issue exspands all records not just selected record

[trevor40]

Does anybody know if I can do this to only the current record without having to click on the little + sign?

This exspands all records not just the selected record
Private Sub Form_Current()
Me.SubdatasheetExpanded = true


End Sub

[June7]

Bing: access vba expand subdatasheet current record

Best I could find.
http://www.tek-tips.com/viewthread.cfm?qid=985375

I don't use datasheet/subdatasheet setup.

[trevor40]

Thanks for that, I'll see if I can find a workaround as well.

[June7]

If not already aware of, might find this interesting http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[trevor40]

Thanks June, but my workaround will still need to be for an imbeded subdatasheet, some thing alone the lines of -

on current expand all subdatasheets, goto selected record on subdatasheet, turn off expand subdatasheet. leaving only the current record subdatasheet open.

Saw something like this in my hunt, just have to remember were I saw it now!