tab moves to wrong record

[Guest]

Hi Everyone
I have a form with subform for data entry. When I tab through my form
everything fooks perfect. But when I inter data in one of the fields and Tab
then it goes to my first record and stops at the first field. On a subform
tab works fine.Any idea of where I went wrong?

Thanks
Barb

 

[Steve Schapel]

Barb,

Do you mean this is just happening with one paricular control? Is this
control the last in the form's "tab orer"? Can you have a look at the
properties and see if there is any macro or event procedure running on
this control, for example its Exit or After Update event? Or, look at
all the code in the form's module, and see if there is any Requery if
the form which might be getting triggered.

 

[Guest]

Hi Steve
thanks, I wrote a requery in there. Ops... Trying to fix on one side....

Barb