Any event triggered when a subdatsheet expand indicator is clicked

R

rpochoda

I have a form which contains a subform in datasheet view. This datasheet has
a subdatasheet. When the form opens, the parent datasheet appears in
expanded display (by Access design). Any of the subdatasheets is expanded
by clicking on the appropriate expand indicator on the left in the parent.
The user can expand the subdatasheet for any record in the parent, whether or
not it's the current record.

I have code that needs to run when a subdatasheet is expanded. The OnEnter
event is triggered when the subdatasheet associated with the current record
in the parent is expanded, but there does not seem to be any event associated
with expanding any of the other subdatasheets. Any ideas how I can handle
this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which event triggered when expanding subdatasheet? 0
specifying which subdatasheet in Access 2003 3
Expanding a multi-level subdatasheet form using VBA 0
Keyboard navigation in forms: expand/collapse a subdatasheet 0
subdatasheet opens automatically 3
Dynamic Naming of Form Button 3
Keyboard navigation in datasheet forms: expand/collapse a subdatas 5
Create form with checkbox les that expand and collapse sections of the form? 0

Top