adding a record from one table to another

C

Cyberwolf

I have 2 tables "Current TB" and "Chargebacks" They both have the common
field of "Line Number" What I want to do is when I type a line number in the
field in my Chargebacks form I want to populate certain fileds with data from
my "Current TB" table. I thought an update query would work but I can't get
the data to show in the current record in my chargebacks form. Any help
would be greatly appreciated.

TIA
 
Top