I am just wondering what the naming convention is to set the focus from one subform field, to another subform field. I assume you put it in the ON_Exit event something like

Forms!MainForm!Subform.Field1.setfocus?

Thanks
Peter Paul

the general convention for refering to a field on a subform is:
Forms![FormName]![SubFormName].Form![FieldName]
Replace what's in the brackets with your own info but "Forms!" and ".Form!" are literal.