I am trying to add a new unbound text box using a DLookup expression in the control source.
I have been over and over this like crazy, and I still get "#Error" in the text box. Is there something obvious that I'm doing wrong? In case it matters, the table "Books" is an linked Excel spreadsheet/table.Code:=DLookUp("[title]","[Books]","[review]=" & [Forms]![Check In Form]![Book ID])
Thanks -