I am running Access 2010 and would like to auto populate text into a number of cells on a form a OBDC connection. I have the connection setup and seems to work fine. I have input the following into a text box (Source Control)
=DLookUp("[Customer]"," [dbo_Job]","[Job]= ' " & [Forms]![Printable CoC Form]![Job] & " ' ")
I have tried a number similar permutation but haven't got it to work.
Thank you for you assistance.