Automated Field Problem

[Only1Abhi]

Hi.

I have a problem that I tried to solve. It's very hard for me but maybe people with good access knowledge can help!

-------------------------------------SCENARIO---------------------------

I have a table called "tblCustomer", with fields:

CustomerID (Autonumber)
Forename (Text)
Surname (Text)


I also have another table called "tblTransaction", with fields:

CustomerID (Number)
CustomerForename (Text)
CustomerSurname (Text)



------------------------------PROBLEM-----------------------------------

When I type the CustomerID in tblTransaction, I need the Forename and Surname from tblCustomer to copy automatically into fields CustomerForename and CustomerSurname of tblTransaction!



Can anyone please help?

Many thanks in advance!

 

[orna]

In the After Update of the CustomerID field:
me!CustomerForename =
DLookup("[Forename]","tblCustomer","[CustomerID]= " & _
me!CustomerID)
where me!CustomerForename is bound to the table tblTransaction
and the same for the Surname

 

[Only1Abhi]

thanks!

But I solved this problem!

I just deleted fields CustomerForename and CustomerSurname from tblTransaction.

That solved it!

Many thanks anyways!

Kind Regards,
Abhi