I have a form I am using to enter customer orders. When I enter the Customer ID I want the Customer Name field to automatically populate with the customers name. I know I should use DLookup for this, but I am having a hard time figuring it out. I will explain more of what I don't understand later, but for now can someone help me get this straight?

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] &"'")