I would like to automatically load 'default' values from another table holding each customer's 'normal' terms, into multiple fields in our 'Sale Contract Form', based on the customer ID (CustID), which is choosen from a Combo box. I need to be able to override the defaults. The fields I'm trying to load the 'default values' into are not named the same as those in the 'Default' Table where data is obtained.

I've tried using the 'DLookup' command in the 'Default Value' property box and that didn't work. I tried 'DLookup' command 'upon enter' event as well with no results. I would appreciate any help to tell me what I'm doing wrong. Thank you in advance.

Example one field in form:
FORM/TABLE = [Sale Contract]
FIELD = [IncoTerms]

want to load 'default' value from
TABLE = [CustomerDefaults] FIELD=[DftlIncoTerms]

The common field between two tables is [CustID].