By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,436 Members | 2,958 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,436 IT Pros & Developers. It's quick & easy.

2007 Split Form Usage / Focus / MVP Folks

P: n/a
I posted this before, but no response. Hopefully the MVP folks will know the

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.



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.
Jul 6 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.