Append Query Problem

[Ninabunny]

I cannot seem to Append the correct record in my Append Query!!&nbsp;&nbsp;I need to Append the old Address to the tblAddress from the frmNames(linked to tblNames).<br>I did this this way.....<br>Private Sub Address_BeforeUpdate(Cancel As Integer)<br>&nbsp;&nbsp;&nbsp;&nbsp;If Address.OldValue = Address.Value Then<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;Else<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Call Appendme(in function module)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub<br><br>Problem is it only appends the old value partially because I made it append the oldvalue in the expression in the query?<br>Can you help me with the code?<br>

 

[elizabeth]

This sounds familiar. Is this a follow on question from a thread that originally had more background information? If so, would you add this follow-on question to the origianl, so that we get the full story?&nbsp;&nbsp;Also it would be helpful if you posted the code for your Appendme function, and specified your results more precisely.