Deleting Records in a Data Base --HELPPP

[uwo]

Hi,

I took a beginners course on using Dreamweaver, then my boss decided to throw me into a huge project in creating this website. Basically, I have a database where someone registers, but cannot create their own password (the password field in my database stays empty). Then I have an admin page, where the admin decide if the person should be able to view the website. If they are, then admin assigns a password to them, and it is emailed to the user.
When I make the admin page, it keeps giving me an error:

**********

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/TaiPanLighting/Admin.asp, line 400

***********

I am wondering if it is because the password field is empty? I applied the "show if not empty" behaviour to it, but it still gives me the error.

Also, on my server behaviors panel, "Delete Record("form 1")" has a red ! beside it. And when I click it, a message pops up saying "original recordset specified in script was not found". What does this mean?

Please help!!!

 

[uwo]

O ya,

I have just changed it so that my database automatically gives the password a default value of '0', so that it is not empty.
But the error still shows up when I try to view it. What should I do?