What to do When I get to Last Field of Form? 1

[HJessen]

I have a form with about 5 sub-forms which are accessed via tab control.

Once I reach the last field of a sub-form how can I (1)continue to the next sub-form/tab. OR (2)if I am on the last field of the last sub-form how do I either stop going anywhere, or go the the next record on the main form?

When my users tab in the last field of the sub-form, it tries to create a new record -- It appears to the user as if the data was lost.

Any help is appreciated.

Thanks. H. Jessen
"Now I know more, and I feel dummer"

 

[ajdesalvo]

In the subforms's Cycle property, set it to Current Record. This way, tabbing from the last field returns to the first field of the same record. Do this in all the subforms.

Happy coding! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[HJessen]

THANK YOU, Anthony!

This worked, and has solved my problem! H. Jessen
"Now I know more, and I feel dummer"