Joe
This should work whether in Access 2007 or earlier. If I get your question
right here is what I think you need to do assuming you are familiar with
Visual Basic for Application (VBA).
In DL2's BeforeUpdate event put this code
If DL2 <> DL1 Then
DL1 = Null
DL2 = Null
Cancel = 1
DL1.SetFocus
End If
The above code will clear whatever was entered in DL1 and DL2 if it is found
that the two are not the same.
You can set the fields'
HTH
Liveson
From: [email protected] [mailto:[email protected]] On Behalf
Of feihu_aiwei
Sent: Sunday, 28 March, 2010 18:29
To: [email protected]
Subject: [ms_access] Data Validation on the form
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
[Non-text portions of this message have been removed]
