table7.AddNew
table7![aname] = Table8![aname] ' object required
table7.AddNew
table7![aname] = Table8![aname] ' object required
Not enough info.
Are table7 and table8 Recordset objects?
Provide the complete procedure, or at least enough to make analysis possible.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.