Form linked to recordset

[Newbie]

Hi,

I have a form that is linked to an ADO recordset - no problems

However, when I add a record - it used to be that once I tabbed past the
last field in the form it would move on to the next new record - in my case
I now have to tab through the fields twice before it moves on to the next
new record.

How can I force it to move to the next new record once I move out of the
last field?

 

[Kelvin]

Check you tab order. If your form is set to cycle through all records then
tabbing from the last field in the tab list should go to the next record.
The last field you mentioned might not be the last tab in the list. Fix the
tab order and it should fix the problem.

To force the tab from a specific field to go to the next record, the best
thing is to create a new invisible text box. Set the tab order for this box
to the box you want plus 1. Then on the OnGotFocus event of this invisible
text box add code.

DoCmd.GotoRecord, , AcNewRec

Kelvin