Hi, I have a table called Tbl_ComboBox, and a form named Form1. On the form I have a combobox where you select an employee code. I need to do a DLookUp from an Unbound text box to auto fill the Name of person that is equal to my selected Combobox value. This is what I have:
=DLookUp("[Name]","[Tbl_ComboBox]","[Employee Code].[Tbl_ComboBox]= " & [Combo2].[Text]). Not working. What am I missing? Please help