Populating one field based upon another

[stuart_adair]

Hello all

Could you please help me out with some syntax. I've got a form with 2 fields.

Text421 displays a value based upon a lookup on a table and works fine.
I want a field called Region to be populated with the value of text 421 after it updates.

I've tried being all logical and in after update on Text 421 entered Me.Region=Me.text421 but that doesnt work.

Making 2 fields match on a form has got to be easy, its just that I'm struggling.

Thanks
Stu

 

[stuart_adair]

Many thanks for the reply. It seems like I'm being overcomplicated and barking-up-the-wrong tree. Lets me post the problem again and try to keep it simple...

I've got a table called 'depots' which has a list of depots and their associated regions.

I've got another table called 'main' which contains lots of customer information, including the depot name, but doesnt contain the region.

I want to be able to produce a report that lists customers (And associated data) grouped by regions.