This is wierd....

[Derek]

Hi,
I have three forms and each has a textbox for date. When i add a book to the database through the add form and when i update that same record with the help of the edit form that i created i get a default date 1/1/1900 in the date textbox in the delete form. What the hell is this date and where is it coming from?Can anyone tell me how do i get rid of this problem.
Thanks alot for any help,
Derek

[Spectre]

If you are using SQL Server, when changing a record field that contains a date (or creating one for that matter), if you pass an empty string "" SQL Server defaults that date field to 1/1/1900. If you want a date field that has no date in it you must pass null.