Username/Password with vba error: "Method or data member not found"

OK, if it's a requirement then I suppose you are stuck with using Excel for the forms.

My first comment still stands though, you should be querying the username/password table to returnt the password for the username entered on the form.