Duplicate Data

T

Trini Gal

Hello,

I have a problem that I can't seem to find the solution to.

I have a table with three fields (Address, Street, Street1), that when put
together maked up a street address.

eg. Address - 100, Street - East Main, Street1 - Street, when added together
for a report becomes 100 East Main Street

My issue is that when the user enters new information into my forms, I want
ACCESS to check to see if when Address, Street, and Street1 is added together
equal data that already exists. And if the data already exist have a pop up
notification box that notifies the users that the data already exists, and
populate all the fields with the existing data.

Is this possible???

Thanks in advance for your time.
 
R

Rick B

Yes. In your table design, make a compound index that consist of the three
fields and don't allow duplicates.

The help files will walk you through making a compound index. Or you can do
a search and read the previous posts on the topic .
 
K

Klatuu

You could use the DLookup function:

If Not IsNull(DLookup("[Address]","TableNameHere","Address = '" & Me.txtAddr _
& "' and [Street] = '" & Me.txtStreet & "' and [Street1] = '" &
Me.Street1 _
& "'")) Then
MsgBox "This Address is Already in the database"
End If

Now, for the real world. You will still have an issue with possible
duplicates because one user may enter "Street" in [Street1] and another will
enter "St", or "St.", or "Str", etc.
One way around that is to create a combo box that will have all the valid
possible street suffixes. I don't know if it is online or not, but several
years ago I did an application that had to have valid exact addresses. The
Postal Service was able to supply me with information on all the rules
surrounding addresses.
 
T

Trini Gal

Klatuu,

Having duplicate in the [Street1] isn't a problem because that is a combo
box. My question to you is, do I add this code to the Form_BeforeUpdate
function?

Also, I have another issue, when Access detects that the data is duplicate,
I want to have the message box say "This address already exists. Do you want
to cancel the changes and go to that record?". I want to have a yes and
cancel button on the message box. So when the user clicks yes, then they are
taken to that record and if they click the cancel button, then Access undo
the current record.

Is this possible?

Thanks so much for your help in advance. I'm going to try the code you gave
me now.

Klatuu said:
You could use the DLookup function:

If Not IsNull(DLookup("[Address]","TableNameHere","Address = '" & Me.txtAddr _
& "' and [Street] = '" & Me.txtStreet & "' and [Street1] = '" &
Me.Street1 _
& "'")) Then
MsgBox "This Address is Already in the database"
End If

Now, for the real world. You will still have an issue with possible
duplicates because one user may enter "Street" in [Street1] and another will
enter "St", or "St.", or "Str", etc.
One way around that is to create a combo box that will have all the valid
possible street suffixes. I don't know if it is online or not, but several
years ago I did an application that had to have valid exact addresses. The
Postal Service was able to supply me with information on all the rules
surrounding addresses.

Rick B said:
Yes. In your table design, make a compound index that consist of the three
fields and don't allow duplicates.

The help files will walk you through making a compound index. Or you can do
a search and read the previous posts on the topic .
Click to expand...
Click to expand...
 
K

Klatuu

The form before update is a good place to put this code. You can do what you
want with the message box. For details, look in VBA editor Help.

Trini Gal said:
Klatuu,

Having duplicate in the [Street1] isn't a problem because that is a combo
box. My question to you is, do I add this code to the Form_BeforeUpdate
function?

Also, I have another issue, when Access detects that the data is duplicate,
I want to have the message box say "This address already exists. Do you want
to cancel the changes and go to that record?". I want to have a yes and
cancel button on the message box. So when the user clicks yes, then they are
taken to that record and if they click the cancel button, then Access undo
the current record.

Is this possible?

Thanks so much for your help in advance. I'm going to try the code you gave
me now.

Klatuu said:
You could use the DLookup function:

If Not IsNull(DLookup("[Address]","TableNameHere","Address = '" & Me.txtAddr _
& "' and [Street] = '" & Me.txtStreet & "' and [Street1] = '" &
Me.Street1 _
& "'")) Then
MsgBox "This Address is Already in the database"
End If

Now, for the real world. You will still have an issue with possible
duplicates because one user may enter "Street" in [Street1] and another will
enter "St", or "St.", or "Str", etc.
One way around that is to create a combo box that will have all the valid
possible street suffixes. I don't know if it is online or not, but several
years ago I did an application that had to have valid exact addresses. The
Postal Service was able to supply me with information on all the rules
surrounding addresses.

Rick B said:
Yes. In your table design, make a compound index that consist of the three
fields and don't allow duplicates.

The help files will walk you through making a compound index. Or you can do
a search and read the previous posts on the topic .



--
Rick B



Hello,

I have a problem that I can't seem to find the solution to.

I have a table with three fields (Address, Street, Street1), that when put
together maked up a street address.

eg. Address - 100, Street - East Main, Street1 - Street, when added
together
for a report becomes 100 East Main Street

My issue is that when the user enters new information into my forms, I
want
ACCESS to check to see if when Address, Street, and Street1 is added
together
equal data that already exists. And if the data already exist have a pop
up
notification box that notifies the users that the data already exists, and
populate all the fields with the existing data.

Is this possible???

Thanks in advance for your time.
Click to expand...
Click to expand...
Click to expand...
 
T

Trini Gal

Hello,

Can someone please help me with this code. When I debug it, no errors show
up. When I test it in the form, nothing happens, the duplicate data is just
saved. I'm sorry to keep bugging about this. I'm fairly new to VB Coding.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("ADDRESS", "LEAKS FOUND", "ADDRESS = '" &
Me.ADDRESS _
& "' and STREET = '" & Me.LOCATION & "' and STREET1 = '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS & "'"
End If

End If

End If

End Sub

Thanks.
 
T

Trini Gal

When I click the compile, no errors show up and when I click the Step Into,
nothing happens, I hear a "ding" and thats all. Is the code even right?

I'm sorry for being such a headache.
 
K

Klatuu

Notice a few cosmetic changes to code. There was only one line that could
really be a problem, there is a ' missing in this line:
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS

The Step Into will not trace the code line by line. Open your form in
Design View then Open your VBA editor, get into the sub you want to trace,
put your cursor on the first line of executable code and press F9. You will
it highlight. No go back to your form, do whatever it takes to get the code
to execute. The VBA editor will pop up and you will see a line highlighted
in yellow. That is the line that will execute next. Then, press F8, the
line will execute and the next line will highlight.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then
(change) varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS]
= '" &
Me.ADDRESS _
(change) & "' and [STREET] = '" & Me.LOCATION & "' and [STREET1]
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
(change) Me.Recordset.FindFirst "[ADDRESS] ='" & varADDRESS
& "'"
End If

End If

End If

End Sub
 
T

Trini Gal

Klatuu,

YOU ARE THE BEST!!!

The code worked great and I was able to step throught it. I have one
problem though. When I try to enter the duplicate date, the message box come
up fine. When I click "NO", the entry is cancelled. When I click "YES", I
am taken to the existing entry. This is where my problem lies. I am taken
to the entry, and then another message box pops up saying "You can't to the
the specified record." Why am I getting this error? Is there a way to fix
this? Below is my code.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" &
Me.ADDRESS _
& "' and [STREET] = '" & Me.LOCATION & "' and [STREET1] = '" &
Me.STREET1 _
& "'")

If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "[ADDRESS]='" & varADDRESS & "'"
End If

End If

If you can please help me with this I would greatly appreciate it.

Thanks.



Klatuu said:
Notice a few cosmetic changes to code. There was only one line that could
really be a problem, there is a ' missing in this line:
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS

The Step Into will not trace the code line by line. Open your form in
Design View then Open your VBA editor, get into the sub you want to trace,
put your cursor on the first line of executable code and press F9. You will
it highlight. No go back to your form, do whatever it takes to get the code
to execute. The VBA editor will pop up and you will see a line highlighted
in yellow. That is the line that will execute next. Then, press F8, the
line will execute and the next line will highlight.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then
(change) varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS]
= '" &
Me.ADDRESS _
(change) & "' and [STREET] = '" & Me.LOCATION & "' and [STREET1]
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
(change) Me.Recordset.FindFirst "[ADDRESS] ='" & varADDRESS
& "'"
End If

End If

End If

End Sub

Trini Gal said:
When I click the compile, no errors show up and when I click the Step Into,
nothing happens, I hear a "ding" and thats all. Is the code even right?

I'm sorry for being such a headache.
Click to expand...
Click to expand...
 
K

Klatuu

I can't possibly be the best. I don't know the answer to this one for sure.
I believe you have to use a recordset clone and bookmarks to make the record
you want the current record for your form. I have to admit I am weak on that
part.

Trini Gal said:
Klatuu,

YOU ARE THE BEST!!!

The code worked great and I was able to step throught it. I have one
problem though. When I try to enter the duplicate date, the message box come
up fine. When I click "NO", the entry is cancelled. When I click "YES", I
am taken to the existing entry. This is where my problem lies. I am taken
to the entry, and then another message box pops up saying "You can't to the
the specified record." Why am I getting this error? Is there a way to fix
this? Below is my code.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" &
Me.ADDRESS _
& "' and [STREET] = '" & Me.LOCATION & "' and [STREET1] = '" &
Me.STREET1 _
& "'")

If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "[ADDRESS]='" & varADDRESS & "'"
End If

End If

If you can please help me with this I would greatly appreciate it.

Thanks.



Klatuu said:
Notice a few cosmetic changes to code. There was only one line that could
really be a problem, there is a ' missing in this line:
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS

The Step Into will not trace the code line by line. Open your form in
Design View then Open your VBA editor, get into the sub you want to trace,
put your cursor on the first line of executable code and press F9. You will
it highlight. No go back to your form, do whatever it takes to get the code
to execute. The VBA editor will pop up and you will see a line highlighted
in yellow. That is the line that will execute next. Then, press F8, the
line will execute and the next line will highlight.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then
(change) varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS]
= '" &
Me.ADDRESS _
(change) & "' and [STREET] = '" & Me.LOCATION & "' and [STREET1]
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
(change) Me.Recordset.FindFirst "[ADDRESS] ='" & varADDRESS
& "'"
End If

End If

End If

End Sub

Trini Gal said:
When I click the compile, no errors show up and when I click the Step Into,
nothing happens, I hear a "ding" and thats all. Is the code even right?

I'm sorry for being such a headache.

:

Have you run it in debug mode and stepped through it to see what it is doing?

:

Hello,

Can someone please help me with this code. When I debug it, no errors show
up. When I test it in the form, nothing happens, the duplicate data is just
saved. I'm sorry to keep bugging about this. I'm fairly new to VB Coding.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("ADDRESS", "LEAKS FOUND", "ADDRESS = '" &
Me.ADDRESS _
& "' and STREET = '" & Me.LOCATION & "' and STREET1 = '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS & "'"
End If

End If

End If

End Sub

Thanks.

Hello,

I have a problem that I can't seem to find the solution to.

I have a table with three fields (Address, Street, Street1), that when put
together maked up a street address.

eg. Address - 100, Street - East Main, Street1 - Street, when added
together
for a report becomes 100 East Main Street

My issue is that when the user enters new information into my forms, I
want
ACCESS to check to see if when Address, Street, and Street1 is added
together
equal data that already exists. And if the data already exist have a pop
up
notification box that notifies the users that the data already exists, and
populate all the fields with the existing data.

Is this possible???

Thanks in advance for your time.
Click to expand...
Click to expand...
Click to expand...
 
T

Trini Gal

Klatuu,

Thanks so much for helping me. I don't know how to do a recordset clone and
bookmarks. Like I said, I'm new to VB coding. I will keep looking to see
if I can find any help.

No matter, you were very helpful.

Thanks.

Klatuu said:
I can't possibly be the best. I don't know the answer to this one for sure.
I believe you have to use a recordset clone and bookmarks to make the record
you want the current record for your form. I have to admit I am weak on that
part.

Trini Gal said:
Klatuu,

YOU ARE THE BEST!!!

The code worked great and I was able to step throught it. I have one
problem though. When I try to enter the duplicate date, the message box come
up fine. When I click "NO", the entry is cancelled. When I click "YES", I
am taken to the existing entry. This is where my problem lies. I am taken
to the entry, and then another message box pops up saying "You can't to the
the specified record." Why am I getting this error? Is there a way to fix
this? Below is my code.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" &
Me.ADDRESS _
& "' and [STREET] = '" & Me.LOCATION & "' and [STREET1] = '" &
Me.STREET1 _
& "'")

If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "[ADDRESS]='" & varADDRESS & "'"
End If

End If

If you can please help me with this I would greatly appreciate it.

Thanks.



Klatuu said:
Notice a few cosmetic changes to code. There was only one line that could
really be a problem, there is a ' missing in this line:
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS

The Step Into will not trace the code line by line. Open your form in
Design View then Open your VBA editor, get into the sub you want to trace,
put your cursor on the first line of executable code and press F9. You will
it highlight. No go back to your form, do whatever it takes to get the code
to execute. The VBA editor will pop up and you will see a line highlighted
in yellow. That is the line that will execute next. Then, press F8, the
line will execute and the next line will highlight.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then
(change) varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS]
= '" &
Me.ADDRESS _
(change) & "' and [STREET] = '" & Me.LOCATION & "' and [STREET1]
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
(change) Me.Recordset.FindFirst "[ADDRESS] ='" & varADDRESS
& "'"
End If

End If

End If

End Sub

:

When I click the compile, no errors show up and when I click the Step Into,
nothing happens, I hear a "ding" and thats all. Is the code even right?

I'm sorry for being such a headache.

:

Have you run it in debug mode and stepped through it to see what it is doing?

:

Hello,

Can someone please help me with this code. When I debug it, no errors show
up. When I test it in the form, nothing happens, the duplicate data is just
saved. I'm sorry to keep bugging about this. I'm fairly new to VB Coding.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("ADDRESS", "LEAKS FOUND", "ADDRESS = '" &
Me.ADDRESS _
& "' and STREET = '" & Me.LOCATION & "' and STREET1 = '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS & "'"
End If

End If

End If

End Sub

Thanks.

Hello,

I have a problem that I can't seem to find the solution to.

I have a table with three fields (Address, Street, Street1), that when put
together maked up a street address.

eg. Address - 100, Street - East Main, Street1 - Street, when added
together
for a report becomes 100 East Main Street

My issue is that when the user enters new information into my forms, I
want
ACCESS to check to see if when Address, Street, and Street1 is added
together
equal data that already exists. And if the data already exist have a pop
up
notification box that notifies the users that the data already exists, and
populate all the fields with the existing data.

Is this possible???

Thanks in advance for your time.
Click to expand...
Click to expand...
Click to expand...
 
R

Rajesh

Hi there,

the error message you got seems to be due to this reason posted on
microsoft.com

http://support.microsoft.com/default.aspx?scid=kb;EN-US;128195

try the suggestions put forth by Microsoft!

hope this solves your problem!


regards

Rajesh V R

Trini Gal said:
Klatuu,

Thanks so much for helping me. I don't know how to do a recordset clone
and
bookmarks. Like I said, I'm new to VB coding. I will keep looking to
see
if I can find any help.

No matter, you were very helpful.

Thanks.

Klatuu said:
I can't possibly be the best. I don't know the answer to this one for
sure.
I believe you have to use a recordset clone and bookmarks to make the
record
you want the current record for your form. I have to admit I am weak on
that
part.

Trini Gal said:
Klatuu,

YOU ARE THE BEST!!!

The code worked great and I was able to step throught it. I have one
problem though. When I try to enter the duplicate date, the message
box come
up fine. When I click "NO", the entry is cancelled. When I click
"YES", I
am taken to the existing entry. This is where my problem lies. I am
taken
to the entry, and then another message box pops up saying "You can't to
the
the specified record." Why am I getting this error? Is there a way to
fix
this? Below is my code.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] =
'" &
Me.ADDRESS _
& "' and [STREET] = '" & Me.LOCATION & "' and [STREET1] =
'" &
Me.STREET1 _
& "'")

If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go to
that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "[ADDRESS]='" & varADDRESS & "'"
End If

End If

If you can please help me with this I would greatly appreciate it.

Thanks.



:

Notice a few cosmetic changes to code. There was only one line that
could
really be a problem, there is a ' missing in this line:
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS

The Step Into will not trace the code line by line. Open your form
in
Design View then Open your VBA editor, get into the sub you want to
trace,
put your cursor on the first line of executable code and press F9.
You will
it highlight. No go back to your form, do whatever it takes to get
the code
to execute. The VBA editor will pop up and you will see a line
highlighted
in yellow. That is the line that will execute next. Then, press F8,
the
line will execute and the next line will highlight.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then
(change) varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND",
"[ADDRESS]
= '" &
Me.ADDRESS _
(change) & "' and [STREET] = '" & Me.LOCATION & "' and
[STREET1]
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes and go
to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
(change) Me.Recordset.FindFirst "[ADDRESS] ='" &
varADDRESS
& "'"
End If

End If

End If

End Sub

:

When I click the compile, no errors show up and when I click the
Step Into,
nothing happens, I hear a "ding" and thats all. Is the code even
right?

I'm sorry for being such a headache.

:

Have you run it in debug mode and stepped through it to see what
it is doing?

:

Hello,

Can someone please help me with this code. When I debug it, no
errors show
up. When I test it in the form, nothing happens, the duplicate
data is just
saved. I'm sorry to keep bugging about this. I'm fairly new
to VB Coding.

Private Sub Form_BeforeUpdate(Cancel As Integer)

Dim varADDRESS As Variant

If Me.NewRecord Then

varADDRESS = DLookup("ADDRESS", "LEAKS FOUND", "ADDRESS
= '" &
Me.ADDRESS _
& "' and STREET = '" & Me.LOCATION & "' and STREET1
= '" &
Me.STREET1 _
& "'")
If Not IsNull(varADDRESS) Then

If MsgBox("This record already exists." & _
"Do you want to cancel these changes
and go to that
record instead?", _
vbQuestion + vbYesNo, _
"Duplicate Address Found") _
= vbYes _
Then
Cancel = True
Me.Undo
Me.Recordset.FindFirst "ADDRESS=" & varADDRESS
& "'"
End If

End If

End If

End Sub

Thanks.

in message
Hello,

I have a problem that I can't seem to find the
solution to.

I have a table with three fields (Address, Street,
Street1), that when put
together maked up a street address.

eg. Address - 100, Street - East Main, Street1 -
Street, when added
together
for a report becomes 100 East Main Street

My issue is that when the user enters new information
into my forms, I
want
ACCESS to check to see if when Address, Street, and
Street1 is added
together
equal data that already exists. And if the data
already exist have a pop
up
notification box that notifies the users that the
data already exists, and
populate all the fields with the existing data.

Is this possible???

Thanks in advance for your time.
Click to expand...
Click to expand...
Click to expand...
 
Top