How to write set of code for password in module

[Sangpo]

i mean it works fine now. I am so careless in typing.
sangpo

 

[RainLover]

pr2-eugin

Don't you mean DLookup not DCount.

 

[pr2-eugin]

RainLover, I know it sounds really crazy, but the OP has a table called UserT which has field UserID and passWord.. Which have data as,

[B]userID    passWord  [/B]    
1234      1234     
dra       dra     
kunzang   kunzang     
qc        qc 
sangpo    sdpthealth

the OP is not looking to match Passwords with the UserID, but just seeing if a password exists in the table.. if user 'qc' types in password as 'dra', it can be accepted.. Though DLookUp works, DCount works the same way in this case.

 

[RainLover]

Sounds strange, but as the user is just trying to learn code then go for it.