Sub datasheets

[news.sydney.pipenetworks.com]

Hi,
I have a datasheet with a sub datasheet. This shows each data item with
the
usual "cross" button on the very far left hand side you can click on to make
the
sub data sheet drop down.
I found an event "on enter" of the sub data sheet to trigger when someone
clicks
to view the sub data sheet and I was wondering if anyone knows how to use
VBA code to open and close this sub datasheet?

Acc Ver: A2K2
OS: Win2K

Thankyou

 

[John Vinson]

I was wondering if anyone knows how to use
VBA code to open and close this sub datasheet?

Datasheets have VERY limited event capability. You may want to
consider using a Form with a Subform instead; these have a rich event
model, in contrast to datasheets.