Getting data from Related parent table

[husvag]

Hi,

I have 2 tables in one Access database: Contact Db and Client Db. I want to update Contact Db and set the field CompanyName equal to the related Client's Name (field: Name1) if it is does not already have a value.

I have written this:
UPDATE [Contact Db]
SET CompanyName = [Client Db].Name1
WHERE Len(Nz(CompanyName)) = '0'
AND [Contact Db].ClientNumber = [Client Db].CustomerNumber;

And it pops up asking me to "Enter Parameter Value" for Client Db.Name1...

Why? and what am I doing wrong?

[ADezii]

Sorry! The old Double Post again!

[ADezii]

UPDATE [Contact DB] INNER JOIN [Client DB] ON [Contact DB].ClientNumber = [Client DB].CustomerNumber SET [Contact DB].CompanyName = [Name1]
WHERE [Contact DB].CompanyName Is Null;