I used the code that Preeti posted ...
http://www.vb-world.net/ubb/Forum3/HTML/001380.html

and it works great ... NOW the problem I am having is that if I run the form ... it puts the blank record in the database .. and if I don't add a something and just close down the form ... the next time I try to run the form it gives me an error ... because the primary key is set to no duplicates ...

Is there anyway I can post bogus data or delete the blank record ... if I don't enter any information?

HELP ....