DTPicker problem.. need help here

[SonECrocket]

I am assuming that if you are using sql you are selecting the case from the database. I also assume that the database will have an open and close date for the case. In setting the current date and null for close date when creating the case for the first time. Then use the update command to update the sql database with the information needed. Then when select the case to close it use the current date and just update the close date in the database using the update command again. If that isn't it then we need to know where the data is being retrieved from/or stored and how you are getting the information into your VB program

[squrel]

Thank u very much to all.... it helped me a lot
the way u told me to do its the best way and wil do tht way