Main form scrolls on all subform rows only when using Tab control

[ddw23]

Hello Everyone. Wehave Access 2003. I need to modify our current database.

Currently I have the following:

Contracts edit form - users can view (can't edit) alreadyentered contracts but can add activity (contracts status subform) needed tothat contract.
Contracts status subform - activity on a contract (asmentioned above).
This is a 1 to many relationship (1 contract many statuses).
On the contracts edit form, I can scroll through eachcontract one at a time.
Works fine until I put the subform on a tab control. Thefollowing is what happens:

When I scroll through to view each contract, if thecontracts status subform has more than one row of information, the program scrollsthrough that number of rows before it moves to the next contract.
It appears to be reading from the contracts status form. Itonly does this when I use the tab control.

Can anyone advise me as to what I need to do to make thiswork properly? I don't want it to scrollthrough every row on the contracts status subform.

Thank you!

[Missinglinq]

Normal behavior, when tabbing through a Record, is to advance to the next Record when leaving the last Control in the Tab Order. As I said in the Double-post for the thread, you may simply need to use the mouse to get back to the Main Form.

Alternately, you could try setting Focus to a Control on the Main Form, using the OnExit event of last Control, in the Tab Order, on the Subform.

It has occurred to me, on re-reading your post, that you could also go to Properties - Other and set the Cycle Property to Current Record; this would prevent the automatic tabbing to the next Record, but would then necessitate using the mouse to navigate to the next Record, if you needed to do that, and would also require the mouse in order to return to the Main Form.

Linq ;0)>

[ddw23]

Thank you! This project has been put on hold until after year end.

[Missinglinq]

Get back to us when you reactivate it.

May you and yours have a Happy New Year!

Linq ;0)>