URGENT HELP NEEDED : SetFocus subform to subform
- Thread starter Will04
- Start date
nexshark,
I just realized that I asked for forms and relationship for another thread you posted in.
Here, you asked how to automate the setfocus cursor, correct? As usual, there's more than one way to skin a cat here.
1) You can add a AfterUpdate event to every subform to move the cursor to the next logical subform. Be consicious that the behavior may be confusing to some users, especially if they are expecting to enter more than one record per subform before moving on to next subform.
2) I put in a unbound label which tells my user they can use Ctrl-Tab to tab between subform. Not automatic, but at least my user knows and can use it if so desired.
3) To really make the process easy as possible for your users, create either one or two command button(s) on each subform. One button would say "New Record", and another would say "Move on to next subform" (or something to the effect). First button is just optional, as you can simply just tab through the subform to get to a new record without help from a button. But the second button can be tabbed onto and spaced or entered without a mouse click. In the second button's OnClick Event, issue an command to save the record (This will trip any validation checks you may have built in and if record fails validation, it will be cancelled without any trouble) then set focus to next subform's first control in similar manner described earlier.
4) Instead of having one big forms with several subforms, use tab control to logically place subforms within each tabs, and give your users a mean to access the tabs with keyboard (I'm sure this can be accomplished but don't have any idea how I'd go about it as I've never tried this myself.
) or at least using buttons as described in 3 to access various subforms-tabs.
Whether you choose, remember this: Your application is a steaming pile of crap if it doesn't behave like every other applications in Windows (or insert whatever OS we're talking about). You want to think carefully about how you want to present the form to your users and make it work with what they may expect it to do. I'm sure plenty of people has been annoyed with MS's Word trying to be helpful and auto-format something like ME to Me when you actually mean ME. As result you need to take *extra* step to undo the formatting... where's the convenience in that?
So, I trust you will consider about how you want to implement the solution to make tabbing through forms easy as possible for your users.
I hope that helps and good luck.
I just realized that I asked for forms and relationship for another thread you posted in.
Here, you asked how to automate the setfocus cursor, correct? As usual, there's more than one way to skin a cat here.
1) You can add a AfterUpdate event to every subform to move the cursor to the next logical subform. Be consicious that the behavior may be confusing to some users, especially if they are expecting to enter more than one record per subform before moving on to next subform.
2) I put in a unbound label which tells my user they can use Ctrl-Tab to tab between subform. Not automatic, but at least my user knows and can use it if so desired.
3) To really make the process easy as possible for your users, create either one or two command button(s) on each subform. One button would say "New Record", and another would say "Move on to next subform" (or something to the effect). First button is just optional, as you can simply just tab through the subform to get to a new record without help from a button. But the second button can be tabbed onto and spaced or entered without a mouse click. In the second button's OnClick Event, issue an command to save the record (This will trip any validation checks you may have built in and if record fails validation, it will be cancelled without any trouble) then set focus to next subform's first control in similar manner described earlier.
4) Instead of having one big forms with several subforms, use tab control to logically place subforms within each tabs, and give your users a mean to access the tabs with keyboard (I'm sure this can be accomplished but don't have any idea how I'd go about it as I've never tried this myself.
) or at least using buttons as described in 3 to access various subforms-tabs.Whether you choose, remember this: Your application is a steaming pile of crap if it doesn't behave like every other applications in Windows (or insert whatever OS we're talking about). You want to think carefully about how you want to present the form to your users and make it work with what they may expect it to do. I'm sure plenty of people has been annoyed with MS's Word trying to be helpful and auto-format something like ME to Me when you actually mean ME. As result you need to take *extra* step to undo the formatting... where's the convenience in that?
So, I trust you will consider about how you want to implement the solution to make tabbing through forms easy as possible for your users.
I hope that helps and good luck.
