My site works ok, and I can add, delete and update the database but I have this problem where I cannot leave any field blank. What I want to do is to have someone enter a record in the db but it will not be complete after few days someone else will update the database, so my problem is how to enter some of the fields while leaving the rest blank

Greetings xlarge:
I'm not sure how any of the active members on this list would respond, but from my limited knowledge, you would have to make sure your Database allows null (empty) values in the all of your fields or just the fields that you want to allow to be blank. In Microsoft Access, I believe it's to set the field to Not be required. Hope this helps.

In access there is a property for a field that is "allow empty string".
Required is another issue.

Rick Harding
U of M CS Student / Network Admin for MSU FAME
www.ricks-web.info
"Techies just think differently...at least that's what they keep telling me"

If you are using Access DB make sure that "Allow Zero Length" is set to YES and "Required" is set to NO.

Oh by the way, here is a link that i ran through while browsing. Hope this is what you are looking for.

www.robgt.com/ultradev/tutorials/blankentries.asp

Thanks guys, isn't easy when you know how.