Hi Mike,
I did not want to give some critique on your code, you did sound so proud.
And there is nothing wrong to start with doing things even if it is not the
best way. But now that Tom did it a little bit, I give you the advice to
change this.
strsql = "Select username FROM tblSecurity"
If you put in here a where clause (there is a nicer way to do it, but this
shows it fine)
strsql = "Select username from tblSecurity WHERE username = '" & trim(txt)
& "'"
Then your system has only to do one read. and if it exist in the first read
you have it.
What Tom said was more efficiency in coding, it does not give you any
advantage in your program itself. With this it goes a lot faster (except
when you have 1 user than it is slower) :-).
I now can see that it is not, but your approach looks like the webform old
ASP style, but that will soon also change in the way Tom said I think.
But it is good you did found it yourself, it is the same as what I did tell
in my message with the difference you use the do while and I was telling you
the while. The do while you use is more from this time, but I did not wanted
to change your basic code to much then.
I hope this helps a little bit.
Cor