Save and reselect record rather than tabbing out

[mhill31]

I have a couple of subforms on a main form that are in datasheet view. There are just three fields in each. I want to tab out of the third field to save the record but I want to reselect the same record instead of going on to a new record.

I also have subforms on this same main form that are in regular form view. I was able to stop them from going to a new record by setting the cycle property to current record. The datasheets are also set up this way but tab continues to carry it to the next record instead of back to the first field of the current record.

Can anyone help?

 

[charityg]

in the lostFocus event of the last field use:

txtbox1.setfocus

where txtbox1 is the name of your first field

 

[mhill31]

It worked. Thank you very much!