Database Table1 Update Table 2 Problems!

[Cheyenne]

Hello,

How do you update one table based upon another?

I need to get five fields out of database table one and save those values
into the same field names into table2. I'm using DAO and Access 2000.

The ProductID number is the same in both tables and so is a CID.

example

'Define what to get out of the database prior to displaying
Cost.Cs Val(Form1.Text1.Text)

How do I do that?

Thanks for all the help in advance.