Have two tables with identical fields (access 2002).
Trying to combine DATA.
I created two recordsets based on these two tables.
then I used code that looks like this.:
with rstmain
..edit
rstmain(3) = rstadd(3)
..update
When I run this I get error message 3709 (The search key was not found for any
record"). When I "trap" the error it occurs on the line of .update
If I then determine what is in rstmain(3) and rstadd(3), the correct
information is in both places. However the table on which rstmain is based does
NOT have the new information
Any suggestions please.
Thank you for the help in advance.
Trying to combine DATA.
I created two recordsets based on these two tables.
then I used code that looks like this.:
with rstmain
..edit
rstmain(3) = rstadd(3)
..update
When I run this I get error message 3709 (The search key was not found for any
record"). When I "trap" the error it occurs on the line of .update
If I then determine what is in rstmain(3) and rstadd(3), the correct
information is in both places. However the table on which rstmain is based does
NOT have the new information
Any suggestions please.
Thank you for the help in advance.