Yes it is the first column. I will try 2 and see if that brings up the right text.
I also tried that DLookup and I just get a blank in the text box. Is this the right code for the DLookup function.
=DLookUp("[Company Number]","[Clients]","[Text52] = Form.[Combo6]")
I also tried that DLookup and I just get a blank in the text box. Is this the right code for the DLookup function.
=DLookUp("[Company Number]","[Clients]","[Text52] = Form.[Combo6]")