Hi, try this
txt_CustomerName = DLookup("[fld_CustomerName]", "tbl_Customer", "[fld_CustomerID] = '"& Forms![frm_Orders]![txt_CustomerID]&"'")
textbook that u going to display = DLookUp("[the column you want]", "[from the tble name]", "[the column u want to compare with] = '"& Forms![form name]![textbox of the form use to compare] &"'")
|