Register Form w/ Error Handling VBA Code

[jrosen12]

I've been trying to google possible solutions to what I'm looking for. I find a mixture of what I want to do, but whenever I implement the examples and alter to what I need, it's just not working. It could be just the lack of understanding of how the error handling works in VBA.

I have a registration form that I'm playing around with. I'd like for it to do the following:
* If all conditions are met (username doesn't match a record on tblUser, both password fields match each other) then the username and password will be added to the table.
* If there is an issue with the username matching a record on the table tblUser, then display an error message
* If the password and the "reenterpassword" text does not match, then display an error message stating so.

I've been able to accomplish the password/reenterpassword part just fine; however, I am having difficulty with the username error handling.

Any suggestions?

[June7]

Post code and/or the db for analysis.