Link to home
Start Free TrialLog in
Avatar of Idarac
Idarac

asked on

MS Access 2010 subdatasheet

My problem is I have a subform datasheet Test1.frm and a nested subdatasheet on that subform.

When I open and run the form Test.frm if I click into the subform datasheet and press the left arrow or right arrow only the subform moves to the right and left, the subdatasheet does not mover, Also if I click into the subdatasheet and use the right/left keys only the subdatsheet moves but the subform does not.
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

As far as I know, this is by design and not to control.

/gustav
Avatar of Idarac
Idarac

ASKER

So is this something I have to live with?
I think so. There is no event to catch when clicking the arrow buttons.

/gustav
Is this a subdatasheet generated by Access, or is this an embedded subform that is being shown in Datasheet view?

I ask because if you are using the "native" subdatasheet as generated by Access, you may be able to switch over to an embedded subform (or sub-subform, as the case may be) in Datasheet view and use that, which may move in concert with your first subform. There are some restrictions on this - if I recall, you can only show the sub-subform in datasheet view if the first subform is also in datasheet view - so I'm not sure this will solve your issue.
Avatar of Idarac

ASKER

I have a subform which is in datsheet view in a form and that subform has a nested datasheet. Make sense?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Are you sure you meant to accept my comment as a solution? If you did, then can you explain why you awarded a B grade?