how do i create a login dialog box in my database that does this,
1. there are two blank textboxes. one for username, and one for password.
2. when the user clicks the submit button, it will look for a match of the username in the table, then checks if the password entered in the dialog box matches the password record in the database. if not match, it will not login.
what i've created is two textboxes, but the username value appears on the dialog box. i used validation rules so that the user specified in the validation rule can access the database. however, if i want to add new user, i have to modify the validation rule. i don't want it that way. i want it to search the table for matching username.
help!