This must be easy - but I have spend ages trying various ways and failing ...
See frmAddCustomers. (Table is tblCustomers with several joins via Combos)
Click "Add Customer" button in frmAddCustomers
Note the "REGION" field which joins via a combo to tblRegion.
The Region chosen will determine the default delivery charge
WHAT I NEED:
Simply after the "Region" is chosen I want to set [tblCustomers].[DelCHarge]
(I have tried numerous ways to do this but am failing badly!)