Subform navigation

[JeepsR4Mud]

Hello,

I have three forms (one main and two subforms)

I can't remember how to go from the last field in one subform to the field in the next subform.

My thought was to do it through the ENTER key. Tab, going to a new record in the same subform, and Enter taking me to the next subform.

I also think it is a VB code, but I can't remember it.

Can anyone help?

Thanks.

Gayle Ann

 

[jtvcs]

Put this code on the LostFocus property of the last field on the first subform, which when the user tabs it will move focus to the frist field you have on the second subform... Forms![main Form name]![second Subform name].SetFocus HTH JT