depdate1 should be your variable name which contains the date value. When using an Update statement in ADO you generally have to wrap the date value in single quotes, not the variable but the date. Therefore ensure that your single quotes are within the double quotes (string builders). Are you writing in C# or VB?

Wes


>hi Wes,
>
>i got this error.
>
>(387): The name 'depdate1' does not exist in the class or namespace 'bankrecon.Form1'
>
>any ideas? thanks.