I'm using access 2003, with the + sign i can collapse my subdatasheets.
I'm using the form/table view (all records shown at the screen).
When opening the form in the on open event I placed
RunCommand acCmdSubdatasheetExpandAll
This works fine and collapses all the subdatasheets in my form at once.but..
I would like to perform this conditionally. If my main form meets a certain criteria the subdatasheet should collapse when opened.
For instance Jason has played two matches, the others didn't play a match and the subdatasheet is empty. My form should popup like this
Jason mickols 01-01-2005
- 4 games 2 matches
Piet Verheij
Hans Van den Brink
How do I reach this goal?
I'm using the form/table view (all records shown at the screen).
When opening the form in the on open event I placed
RunCommand acCmdSubdatasheetExpandAll
This works fine and collapses all the subdatasheets in my form at once.but..
I would like to perform this conditionally. If my main form meets a certain criteria the subdatasheet should collapse when opened.
For instance Jason has played two matches, the others didn't play a match and the subdatasheet is empty. My form should popup like this
Jason mickols 01-01-2005
- 4 games 2 matches
Piet Verheij
Hans Van den Brink
How do I reach this goal?
