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

  • Thread starter Thread starter William Wenjie Wang
  • Start date Start date
W

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?
 
Any idea what might cause the tabbing problem?
Click to expand...

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)
 
John Vinson said:
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)
Click to expand...

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?
 
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?
Click to expand...

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)
 
Back
Top