Update Field When Another Field Changes

[PSOSSA]

I'm trying to set up a form to automatically populate certain fields when a user chooses a selection from a drop-down list. I know I have to use the AfterUpdate command, and I have found several different 'solutions' for this on the web, but nothing is working for me.

Layout is like this:
Table1.Column2 has an entry of 'ABC123'.
Table2.Column2 is blank.

I want to update Table2.Column2 with the value of Table1.Column2.



I have tried:
UPDATE Table2
SET Table2.Column2 = (SELECT Table1.Column2 From Table1 WHERE Table1.Column3 = Table2.Column3)


UPDATE Table2
INNER JOIN Table1 ON Table2.Column3 = Table1.Column3
SET Table2.Column2 = Table1.Column2
WHERE Table1.Column3 = Table2.Column3

In both cases, the query comes back blank.

Your help is appreciated!

[June7]

Why are you duplicating data into another table?

Don't need the WHERE clause, although don't think it is the issue and the second query should work.

[PSOSSA]

I'm trying to tie several tables together. The idea is table1, table2, and table3 each hold data exclusive to specific devices. The data is then correlated into table 4. Since users can choose any entry from table1, table2, and table3 I can't link them together before hand.

And, I have just been told that everything I'm trying to do is moot because we actually have a product to do what I am trying to do. Oh well, it was a fun learning experience.

Thank you!