Does anyone know of functionality that would compare tables, SP, View in two
give the differences.
Be Cool, Salutes from Chile.
I am trying to compare two fields in two tables and then change the
value(boolean) of one field in one table based on the value in the other
table. I have written the following code which should work but does not.
Where am I going wrong?
Private Sub cmdfindactive_Click()
Dim dbs As Database
Dim rstnew As Recordset
Dim rstold As Recordset
Set dbs = CurrentDb
Set rstnew = dbs.OpenRecordset("accinfo")
Set rstold = dbs.OpenRecordset("accinfo_old")
Do While Not rstold.EOF
Do While Not rstnew.EOF
If rstnew![area/org] = rstold![area/org] Then
![active] = rstold![active]
![active].Value = False