A2007 Split Form Datasheet - Setting Focus

[tommg]

In an Access 2007 'split form', how can I programatically set the focus to
the datasheet part of the form?

This has been asked before, but I cannot find any answer. Is it simply not
possible?

Any help appreciated!
Thanks!
Tom

 

[Maurice]

Hi Tom,

As far as I know it can't be done. When looking in code you'll find that you
can set the datasheet to editmode and read only mode and that's about it.
It's a strange object because when looking in design you don't actually see
the datasheet it looks like it's created on the fly (preset) and thus the
focus will always be set on the first field in the single part of the form.