Please Help with code used on user/pass form

[eforce]

I'm planning on migrating my application to java and so I'm attempting to create my own security (user/pass) form with MS Access to sort of simulate the workgroup security.

Ok, I have a table I call "tblSecurity" with two fields (user & password)

I've created an unbound form that accepts the username value into the "txtuser" field and the password value into the "txtpassword" field.

I want these values to be checked against the "tblSecurity" table and if there is a match then, I would like for a query to execute which would contain my where clause Ex: "Where Forms![Login]![txtuser] & Forms![Login]![txtpassword] = tblSecurity.username & tblSecurity.password" (I'm using concatenation as you can tell)

And Now, My Main Form opens

If there is no match found I would like for the program to simply close and I know how to accomplish that (close the program that is)


Please Help!

 

[George Too]

Hi eforce,

Check this thread
http://www.access-programmers.co.uk...readid=27629&highlight=user+name+and+password

Also, there are lots of postings regarding your question. Just do a little search and read away.

Hope it helps,

George