Moving between tabs in a multi-tab form

[Bob in Tampa]

Hi, everyone! : )

I have recently "converted" a single view form to six tabs to minimize the
clutter in the screen. Everything works fine - except (there's always an
except!):

When I leave the lastfield on tab1 in record1, I end up at the firstfield in
tab1 on record2, and I'd like to be at firstfield, tab2, record1.

Intuitively I thought that would be the default, but I'm obviously mistaken.

Can someone help me with the appropriate code or equation to put in "On
Exit" of the lastfield or other appropriate location?

Thanks
Bob Loder
Tampa, FL

 

[Al Campagna]

Bob,
Sounds like that last field on tab1 is the last field on the form's tab
order. Probably the CYCLE property of your form is set to All Records. Try
setting it to CurrentRecord.
That prevents you from tabbing to another record after the last tab
field.
Now, use your View/TabOrder to set Tab2 first field right after Tab1 last
field, etc... etc... for all your fields.

 

[Bob in Tampa]

Thanks, Al,

I do want it to cycle to the next record after I move through ALL fields on
ALL tabs.

The balance of your reply hit it right on the head, and I feel really
stupid!

It seems the more one learns about programming (just starting to write VBA
code), the harder it is to keep all of the basics and obvious in one's head.
Thanks for bringing me back to earth!!

Bob Loder
Tampa, FL