Keyboard navigation in datasheet forms: expand/collapse a subdatas

[Norbert]

I'm looking for a possibility to expand a subdatasheet not by a
click on the expand indicator ('+'), but by a keystroke.

I'm also looking for an event I could react when the expand indicator is used.

Can anyone help me please.
Thanks

 

[Wei Lu]

Hi Norbert,

Thank you for your post!

Access form does not provide a Keystroke to the expand indicator.

As for the event when you click the expand indicator, I think you may use
the On Enter event of the subdatasheet. When you click the expand
indicator, this event will be raised.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Norbert]

Hello Wei Lu,

Thank you for your help.

You said: Access form does not provide a Keystroke to the expand indicator.
Question: Is there a property or similar which I could use to code to expand
the subdatasheet?

I tried to use the On Enter event of the subdatasheet for the expand
indicator.
The On Enter event has the disadvantage that the cursor may still be in a
different row to that one where you click the expand indicator. Is there a
workaround for that?

 

[Wei Lu]

Hi Norbert,

Thanks for the update.

I don't think there is any property you could use to code to expand the
subdatasheet.

As for the OnEnter event, I tested in my side, the cursor went into the
subdatasheet. I am not sure whether this meet your requirement. So would
you please provide your expect behavior of this event?

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Norbert]

Thank you for your patience and your help. I very appreciate that.

I try to describe what behavior I expect.
After clicking the expand indicator I would like to jump to a certain row of
the subdatasheet.
Which one depends on a value of the main row the indicator was clicked.
The subdatasheet contains a lookup of possible values you can enter in a
field of the main row and I want to jump to the subdata row with the current
main row value.

But after clicking the expand indicator the cursor may still be anywhere and
I can't evaluate the value of the main row the indicator was clicked.
The subdatasheet doesn't get entered by clicking the expand indicator. At
least not in my form.

Scenario:
Actually I wanted to do all that by keyboard control.
Expanding the subdata of the current main row by a function key ->
jump automatically to the current value -> change it by cursor control ->
entering this value to the main row by an enter-key stroke.

Any ideas?

 

[Wei Lu]

Hi Norbert,

Sorry for the misleading. I checked our internal knowledge base again, and
found that you can use

[Ctrl]+ [Shift]+ [Down Arrow] to expand the subdatasheet and use

[Ctrl]+ [Shift]+ [Up Arrow] to collapse the subdatasheet.

As for your expect behavior of the expand, your description is more like a
master-detail behavior. You may refer the Northwind Sample Database in
Access.

In the Sample Database, there is a form named 'Customer Orders'. This form
provide a master-detail form.

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.