to move tab form one subform to another

[kavi98]

I have a main form and three subforms on it but when i try to move the tab from one subform to another it saves the record and again goes back to the beginning of the same subform,is there a way i can get the tab to go to the next subform.
and when i am one the thrid subform the tab to move to the main form.

 

[mikelt]

You can move from one subform to another by testing the key that was pressed in the KeyDown event procedure.eg.

If KeyCode = 9 then
Forms![MainForm]![Subform].setfocus
Endif

Alternatively, you can program a function key to sendkeys Ctrl-Tab to move between subforms.

 

[kavi98]

i mainly have textboxes,and the procedures which i get for the subform are on enter and on exit.
if i write a procedure in the form which is a subform in another for ,will it work. through the main form.

 

[mikelt]

You will need to write the procedure in the Keydown event of the last, or only, text box of each subform.