Datasheet form with form header

[mcdhappy80]

I'm trying to recreate this form:

The closest I've come to it is this:

I've set all the form properties on mine form as on the form I'm copying.
I've tried deleting controls in the upper part of mine form but as I'm deleting them they are removing themselves from the datasheet.

How do I do it?

Also I'm interested in creating a link effect on the PK record from datasheet form (as You can see on the picture). I know that I need to use the On Click event of the control and that I need to specify filter on the opening form but I don't know how to capture the PK value from the datasheet. Can someone help me with this too (I need VBA code template)?

Thank You

 

[ajetrumpet]

use the DS as a subform, leave some space on top of the DS for the menus. then for the menus, you have plenty of options, some easier than others.

how about...putting images up there as menu options? what about creating your own commands bars from VBA? (commandbars is a collection in access).