subform tabs to new record

S

Sue

I have two forms below and need to tab from the last field of my subform
back to the main form which happend to be a save command. I'm not good at
code, can you help write it for me.

Main Form Name:Add New SH Info
SubForm Name: sbfrm SH Stock Info

Want to go from fied total stock shares in subform to the Save Record
Command in the Main form
 
O

Ofer

In the Lost focus event of the last field in the subform, set the focus to
the field in the main form

Forms![MainFormName]![FieldName].SetFocus
 
Top