Accessing a SubDataSheet in a subform

[Jack]

I am just learning about Subdatsheets.
When I click the "+" to access the subdata sheet, I want that record to
become the current record.
However the previously selected record remains as the current record
therefore the scroll bars aren't shown in the subdatasheet untill you
physically select the record that the subdatasheet is open under. Confused?

I've tried all the event procedueres that I can think of ...like Form on
click etc.. but nothing fires when I click the "+"
What can I do to make the record that I click the "+" on, the Current
Record.
I'd like this for other reasons than just showing the scroll bar.

Thanks for any help

 

[Jack]

I am using Access2000

 

[Tim Ferguson]

I've tried all the event procedueres that I can think of ...like Form on
click etc.. but nothing fires when I click the "+"
What can I do to make the record that I click the "+" on, the Current
Record.

I don't really understand what you are trying to do, but that is chiefly
because I spend most of my time with subdatasheets trying to get rid of
them.

There are no useable events in table datasheets: in fact there are no
useable anythings. You should be using a form to do whatever it is you are
trying to do -- that is what forms are for.

Table datasheets really should only be used for design and debugging.

Best wishes


Tim F