>Hi Vlad,
>
>Have you tried .Refresh?
>
>Regards
I found out ...it was because of a null value so i changed the table structure.But it still doesn't work for particular records.I am creating a new table from a imported text file and the problem seems to be the way my table is designed,not allowing null or zero-lenght strings. Have anuy idea? I am new to Access and VB.
Thanks.
Vlad