How to expand a subdata only for the currrent record?

[Kalle]

Hi,

Access 2007:
Can anyone tell me if there is a way of programmatically expanding a
subdata only for the currrent record in the data being viewed. I
have a data and would like the subdata to expand automatically
whenever the user selects a record which has related records in the
subdata.


Thanks

 

[John W. Vinson]

Hi,

Access 2007:
Can anyone tell me if there is a way of programmatically expanding a
subdata only for the currrent record in the data being viewed. I
have a data and would like the subdata to expand automatically
whenever the user selects a record which has related records in the
subdata.


Thanks

Datasheets - even with subdatasheets - are of VERY limited utility and do not
have much in the way of programmability.

Consider using a Form with a Subform instead. The user will see the data in
the subform only when it exists.