I have a form frmProducts with fields such as ProdID which are based
on tblProducts.
I have a subform in this form SfrmSub where I enter values (all works
well so far)

The problem I am having is that when I tab through SfrmSub and get to
the last tabbed field, it clears the subform as if it were adding a
new set of data to that record (like a new line in a datasheet)

I just want to know how to make it so when I tab from the last field
in my subform, the focus goes to to another subform or another field
in my form. and yes, I did set the focus manually, but it still clears
my subform as if it were adding another set of data to the same
record. Any thoughts?

WhathaveIdone? wrote:

In the subform's property sheet you can set from AllRecords to
CurrentRecord. It won't skip to another field outside of the subform tho.

On Sep 30, 11:49*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
That was perfect. Exactly what I was looking for. I swear I will never
remember all the properties available here.
So when the last field lost focus, I set the focus to the next field
in the parent form and with your suggestion on the records, it worked
perfectly. Thanks for all your help!