NEED HELP --- User needs to be able to "TAB" key to subform

[Keith]

Hi, I hope someone will help here.

My form has tab stops the user uses to enter data. Their are 4 tab stops on
the main form. after the last tab stop it curser needs to go to the footer
where there is a subform displayed. and allow data entry to the first tab
stop on the "sub form". I do not know how to do this .. I have hours into
this again messing up all kinds of work I have done. Will some one please
help me understand what I must do to be able to press the "TAB" key and not
goback to the first field but jump to the subform first field and stay on the
subform untill the data entry is complete????

Thanks

 

[BruceM]

One way is to add a very small text box (.01 x .01, maybe), formatted so
that it looks like the background. Place it last in the tab order. For the
Enter event of the text box:
Me.SubformControlName.SetFocus

 

[Dirk Goldgar]

One way is to add a very small text box (.01 x .01, maybe), formatted so
that it looks like the background. Place it last in the tab order. For
the Enter event of the text box:
Me.SubformControlName.SetFocus

You can even make the text box 0 x 0, for this sort of thing. Its Visible
property has to be sert to Yes, so that it can receive the focus, but it can
be infinitesimal so the user can't possible see it.

 

[BruceM]

OK, thanks. It never occurred to me that a zero-dimensional entity could be
regarded as visible, so I don't think I ever tried.