Two suggestions:
1. Try FLUSH after the insert
2. I have seen situations like this where a very small delay is necessary, like INKEY(1,'HM').
>Hi Tore,
>
>Thank you to suggest for reducing the lines of code, works fine but the problem is when Auditcls table get new record on the top after new INSERT,
>
>The txtLastImportDate extbox still not refresh immediately as expected with
>a new record.
>
>Rgds,