Tabular form

[Jishnu Surendran]

I have a tabular access form in which a text box was inserted with the formula "=Sum([Shares])" where "Shares" represent one of the fields in the form. However, the text box doesn't get updated when I change the field but only when I update the whole line or the tabular record and that too takes place very slow. Can I make the text box update the formula result instantly when I change the field?

[June7]

The record has to be committed to table. Record is committed when: 1) close table/query/form or 2) move to another record or 3) run code to save record.

Code in the data input textbox AfterUpdate event could be like:

If Me.Dirty Then Me.Dirty = False

[Jishnu Surendran]

The record has to be committed to table. Record is committed when: 1) close table/query/form or 2) move to another record or 3) run code to save record.

Code in the data input textbox AfterUpdate event could be like:

If Me.Dirty Then Me.Dirty = False

Thanks! It is working!
However, there is still some lag. I've tries application.echo but with no result.

[June7]

Don't know why the Sum() would have lag.

I've never used application.echo.

[Missinglinq]

How many Records are you dealing with?

Has the database been split?

If 'yes,' where does the backend reside?

Linq ;0)>