Hi Allen,
First thank you.
I asked you befor few days about the Me.refresh and you answer me
("me.dierty" ...) and it;s solved the problem. BUT i have another quation
with this subject:
I have a form base on this big table i talked about (20k records).
from this form i call a vba function that change (by "db.execute" sql
statement) one of the fields in the current record that shown in this form.
to reflect the changes i use: forms![frm1].refresh and as i said it is very
very slow.
I can't use here ".dirty" because the changes made by the function and not
by the form.
Do you have another way to reflect the changes only to this specific record
in the form?
and again, you realy helped me so thanks.
