I have to press tab twice in order to move to next field, if me.recalc is called

[William Wenjie Wang]

Greetings,

I'm using Access 2000 on XP pro.

I have a subform which has tab orders setup properly. I have no problem to
tab forward and backward, if I don't make any changes to the data fields.
If I typing anything in the data field say Field1, and press tab, It causes
flicking and then focus back to the Field1, instead of going to next field.
I have to press tab again in order to move to the next field. In Field1,
I'm handling "After Update" event and performed "me.recalc". If I remove
"me.recalc", the above mentioned tabbing problem will go away. What makes
it more interesting is that if I "View" the subform standalone, I'm not
experiencing the tabbing problem neither. It only happens when use as a
subform!

Any idea what might cause the tabbing problem?

 

[John Vinson]

Any idea what might cause the tabbing problem?

The Recalc, obviously! Why do you feel the need to recalculate the
entire form? Might it be possible to requery some other (calculated)
*control*, rather than the entire form?

John W. Vinson[MVP]
(no longer chatting for now)

 

[William Wenjie Wang]

The Recalc, obviously! Why do you feel the need to recalculate the
entire form? Might it be possible to requery some other (calculated)
*control*, rather than the entire form?

John W. Vinson[MVP]
(no longer chatting for now)

There is really no need to recalc the whole form, but I seems not able to
find a better way to do it;(

Basically, the data is presented as a rows of data, each row has a subtotal
field of some data fields in the same row; it is presented as continuous
form. And I also have a Grand total of data fields displayed as column
header. It's like a spreadsheet:
T1,T2, .............. GrandTotal
field1, fields, ...... subtotalField
field1, fields, ...... subtotalField
field1, fields, ...... subtotalField
field1, fields, ...... subtotalField

The reason I'm doing it is pure due to subtotalFieldis not binded to a
database field and calcuated reault of Field1, Field2, ...; There is also
another calc is to calc subtotal of GrandTotal and display as a column
header!

Is there any better way to implement it?

 

[John Vinson]

The reason I'm doing it is pure due to subtotalFieldis not binded to a
database field and calcuated reault of Field1, Field2, ...; There is also
another calc is to calc subtotal of GrandTotal and display as a column
header!

Is there any better way to implement it?

Rather than Me.Recalc try specifically requerying the subtotal and
grand total textboxes:

Me!txtSubtotal.Requery
Me!txtGrandTotal.Requery

John W. Vinson[MVP]
(no longer chatting for now)