I have a subform on an Access form and in some cases default (or auto fill-in) fields in the subform from values in the main form. I don't want to default the values unless the user tabs to the field in the subform. What I've found is that if I had previously been on a field in the subform, but am now focused on a field in the main form, then scroll through records on the main form, the subform field I last had focus on still gets the Enter and OnFocus events even though from the users's perspective, the cursor is not even in the subform. I guess my question is can I determine in the Enter and OnFocus events in the subform whether the user is really on that field in the subform or scrolling through records on the main form?
Thanks in advance for any ideas.