Update--sorry guys, an oversight.

Here's a new file:
http://www.mediafire.com/?2t4gog7mdxm

For those who've downloaded it, if you'd like to make it so you can only type in something that exists in the database, go into the form, click design view (top left hand symbol with a pencil/triangle thing) and right click on the name field. Click properties, and under data, click Yes in the line "Limit to List".

Sorry bout that. If you guys see any other "bugs" you'd like fixed, leave a message and I'll see what I can do!