I am working in Access 2007 and creating a database to keep track of our volunteers for our C.E.R.T. Group. There is some information that I am requesting that is semi confidential, so when it is entered, I don't want do display it on the screen, but I need to make sure the first field is identical to the second field.
The end user only has access to the forms. My query is built off my table. The field names that need to be compared are: DL1 and DL2. Once focus is removed from DL2, I want to compare both fields to make sure they are identical. If they are not, I want to clear both fields and return focus to DL1. How can I accomplish this? I am sure I need to do my validation on the form, but not sure how. Thanks Joe
