Tabs in a subform

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a form that has two subforms.

Subform 1 contains two comments boxes.
Subform 2 contains some calculations.

I can tab from the main form to Subform 1. Is there any
way to get it to tab from Subform 1 to Subform 2?
(without making Subform 2 a sub of subform1)

A problem I'm running into, is that even though Subform 1
is linked to the main form by ID_No, if a user tabs
beyond comment box two, they are actually tabbing to the
next customer, but just in the subform, not the main form.

So what happens is that they then think they haven't
added their comment, so they put it in again (but for the
wrong person).

So I either need to it to tab from Subform 1 to 2, or
simply prevent Subform 1 from advancing to the next
record if the main form isn't advancing as well.

Wheew!
Suggestions?
Thanks!
 
On your second comment box, you can set a "Lost Focus".
Something like CommentBox1.setfocus

This will jump the tab back to the first comment. You
MIGHT be able to use this to kick it to the other
subform, but I haven't tried it before. Maybe something
along the lines of:
subform2.Field1.setfocus

Hope this helps
JPhillips.
 
Back
Top