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?
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?