how r u opening the recordset.
please send the code for opening the recordset
there could be some error there.
alternatively try opening the recordset, as KEYSET or STATIC

bharat saboo
 
-------Original Message-------
 
From: professional vb
Date: Wednesday, December 18, 2002 08:54:23
To: professional vb
Subject: [pro_vb] login for the first time
 
hi all
I have a login form and a addnew user and password form for the user to 
login to the program, I have the addnew form to load first for you to add 
a new user, But when the user login for the first time i would like this 
screen to check to see if they is a password in the database and go to the 
login in screen but i'm getting a error with this code.


Private sub form_load()
Dim rsLogin As Recordset

if (rsLogin.recordcount) >1 then 'the error is on this line
login.show
else
addnew.show
end if
end sub


please help with code that i can get this to work.
thanks a lot

.