lookup tables in form

[tecassitant]

hi,

i am using access with VBA .i have 2 tables
1)intercompany with fields 2)cfr details with fields
carenumber cfr number
caredate interco total
stocknumber problem description
total adjustment number
claim amount amount
product description
now the stocknumber(1 i.e..,intercompany table) and adjustment number(2nd table are joined fields)now i create a form for cfr details table,now if i enter adjustment number it should automatically pick up the total from(1) and put in interco total(2)and the same way for calim amount and claim must lookup.

i tried with dlookup for this, but did not produce any result ,another problem is the lookup fields for the two tables have different fields names as claim amount in intercompany table and amount in cfr details table,but the field name should not be changed ,with out changing the field names it should lookup from 2 tables and fill the values in the 2nd table on entering the adjustment number.is that possible if yes please provide me with some codings as i am new to access and vba.

thank you
krishnakumar.B