I posted this before, but no response. Hopefully the MVP folks will know the
answer.
I'm not sure how other's are using the new split form, but what I like about
it is I can design the header part of the form with buttons, graphics, etc.,
then use the lower half as a datasheet. I move the splitter bar to
completely hide the detail of the record, and only show the datasheet. This
is nice, because I don't have to have a main form for the buttons, looks,
etc., then use a subform for the datasheet, and when you maximize, the
datasheet will automatically fill the screen.
Problem is this: if you have a button that says "New Customer" or something
to that affect, and you do a newrecord command, followed by a .setfocus
command (to set the focus to the first field), Access will try to set focus
to the detail field (which is hidden by the splitter bar), and not to the
datasheet field. How on Earth does one set focus to the datasheet portion
of a slit form??? There has to be a way, but I've had no luck.
Thanks!
--
Andy
P.S. As one aside: If only the footer would show on a split form with
datasheet, then us developer's would really have it made! You could do one
form (w/ no subforms) that would have a header area, nice looking w/
buttons, graphics, etc., then a datasheet that would adjust to the
resolution of the monitor, then a set footer area where you could place
formatted totals, other functions, etc. As of now, split forms will only
show your form header, but anything in the form footer will not be visible. |