I have a button "Add new Order" which opens a new form where I can enter new orders.
In the form for new orders the Default value for the LE ID is the value selected in the main menu .
I wanted to pick up the customers "Legal Entity Name" from my Customer Table to populate the default value for the Customer Name field in my orders table using the LE ID enterd on the main menu.
In the properties of "Customer Name" for default value I tried the code below
Expand|Select|Wrap|Line Numbers
- = [Tbl_LE_List]![LEGAL ENTITY DESC] where [Tbl_LE_List]![LE ID] = Forms![Frm_Startup]![CMD LE]