Public Sub SearchField3(Find As String, Co As String)
Dim strSQL As String
Dim db As Database
Dim rs As Recordset
strSQL = "Customers"
Set db = CurrentDb()
Set rs = db.OpenRecordset(strSQL)
With rs
Do While rs.NoMatch = True
.MoveNext
.FindFirst...
I have a query that imports one table into another. It duplicates the records from time to time but without any reason. What are some of the reasons why it could be doing this and can I get by without writting a query to find and delete the duplicates?