By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Update problem get error message 3709

P: n/a
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.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.