can't tab between 2 subforms

[MelissaHoo]

I have two subforms and would like to tab right from the last field of subform 1 into the first field of subform 2 (only one record should exist in each). What happens is that the cursor just skips to the next record in subform 1. Also, I tried looking at the main form in datasheet view, and subform 2 does not even appear.

TIA

 

[RickBerem]

Hello,

Not sure if it will do,
but you could try setting subform 1 Cycle property to 'Current Page' instead of 'All records'

Hope it helps you a little.

SG

 

[TheAceMan1]

How are ya MelissaHoo . . .

In the [blue]LostFocus[/blue] event of the last field in subform1:

[blue] Me![purple][b]subform2Name[/b][/purple].form![purple][b]FieldName[/b][/purple].SetFocus[/blue]

See Ya! . . . . . .

 

[MelissaHoo]

Thanks for all replies. I used both suggestions to improve my form.