I've read many, many samples, still can't get this right. Can someone explain all of the important details when using dlookup in a form control. My example is 2 tables, they have a many/one relationship established. It's a classic, I need "suppl_name" from the Suppliers table to be looked up in the "PC_Master" table-based form with the equal fields of the suppl_id that is in both tables. In the supplier table the suppl_id is the primary key. I've tried with both tables and a query. I've tried putting the dlookup expression in both the default value box and the control source box of the text field on the form (lkupSuppl_Name). Do I need the relationship? Am I putting this in the wrong box? I am getting the #Name? error message. Any help would be greatly appreciated.