Macro Access 2000 - eplace table with new data

[JohnSmith]

I have two tables. Table1 and Table2

How can I create a macro that will take the data in Table2 and replace the data in Table where the LastName is the same....?

[Br1an_g]

can be acheived with an UPDATE SQL statment. (Access)

Dim dbs as Database

set dbs = CurrentDB

dbs.Execute "UPDATE Table2 " _
& " INNER JOIN Table1 ON Table2.[Last Name] = Table1.[Last Name] " _
& " SET Table1.[FieldName] = Table2.[FieldName];"

or create the query that carries out your update in access and call it from code

DoCmd.OpenQuery "QueryName", acViewNormal

Not tested but HTH

Brian

[alex_read]

hey, just out of pure interest, what's HTH mean??!?!?

[Br1an_g]

Hope This helps