Help with replacing data in one table to another table for one record

[Travis33]

I have two tables. One called [A] and one called . I then have a form with two textboxes one from the [A]![last] and one from ![current]. I want when I change the data in [current ] the data that was there to replace the data in the [A]![last] table for that paticular record.


I have been working on this for a week and my Boss is getting mad. Please can someone help me before I am out of a job during the christmas season.

Thank You very much

Travis

 

[Travis33]

sorry for some reason the message was not posted right

Here it is againI have two tables. One called [A] and one called . I then have a form with two textboxes one from the [A]![last] and one from ![current]. I want when I change the data in [current ] the data that was there to replace the data in the [A]![last] table for that paticular record.


I have been working on this for a week and my Boss is getting mad. Please can someone help me before I am out of a job during the christmas season.

Thank You very much

Travis

 

[Telsa]

Just to let you know the brackets you place around the B for your second table is actual coding for bolding in this forum!

So you want to update Table A with changes made in Table B?

Mary )