Move focus to same control in next record of a sub form 1

[bxgti4x4]

I have a sub form which displays four records based on a selection in the main form. Each record contains four fields, three of which are for information and the fourth is where data is entered.

Having selected the information required in the main form, the focus the moves to the data entry field in the sub form but, having entered the data, I then have to tab through three fields of the next record before reaching the data entry field.

I have tried using a macro to select the next record and the same contol in that record. This works when I open the sub form on its own but, when I try to use it as part of the main form, I get the message that the sub form is not open.

Is there a way that I can use an "after update" event to move the focus to the same field in the next record?

Best Regards
John

 

[lupins46]

Set the first 3 field to Tab Stop = No

 

[bxgti4x4]

Thanks, that solved the prolem

Best Regards
John