Trying to get a report to use dlookup based on a value on a form (fReportSelect) in the drop down field of LocSelect.
In my report I have the following in a text box:
=DLookUp("Abr","tOffice","Office = " & "'" & ([Forms]![FReportSelect]![LocSelect]) & "'")
But it's not pulling up values from table tOffice.
What is wrong with my syntax?