Sub Datasheet Focus

[dnesci]

I have a form in datasheet view with two nexted sub data sheets. I need to determine which datasheet (main, sub or sub-sub) sheet has the focus. Acitvesheet always returns the main sheet. I'm using 2003.

Thanks in advanced.

Don

 

[boblarson]

I would suggest using subforms instead of subdatasheets because then you can determine what has the focus. Subdatasheets give you little flexibility and options.

 

[dnesci]

Bob,

I first designed with sub forms but the users demanded the sub data sheets as they want the form to expand and collapse as they do with their present Lotus Notes system. Notes is going away at the end of the year and Access is their choosen replacement. So I'm stuck with the datasheets. Sometimes, you don't work with the best situations.

 

[boblarson]

Bob,

I first designed with sub forms but the users demanded the sub data sheets as they want the form to expand and collapse as they do with their present Lotus Notes system. Notes is going away at the end of the year and Access is their choosen replacement. So I'm stuck with the datasheets. Sometimes, you don't work with the best situations.

Yep, sometimes you are stuck. However, I don't have time to go into it right now but you can make it LOOK like subdatasheets are being used but using forms. It does take quite a bit of work but it is possible.