asked on
DLookup in report text box
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","
But it's not pulling up values from table tOffice.
What is wrong with my syntax?
In my report I have the following in a text box:
=DLookUp("Abr","tOffice","
But it's not pulling up values from table tOffice.
What is wrong with my syntax?
Microsoft Access
Last Comment
thandel
ASKER
It's a text value and yes its matches up with the values in the table (the drop down list gets the value from the table I'm dlooking up with.
Is the other report open? The implication of your syntax is that some form or report is referencing a different form or report. Otherwise, the syntax would be:
=DLookUp("Abr","tOffice","
You might also be missing quotes:
=DLookUp("Abr","tOffice","
=DLookUp("Abr","tOffice","
You might also be missing quotes:
=DLookUp("Abr","tOffice","
ASKER
It's a form and yes the form is open.... I tried both your suggestions but I get an error "The expression you entered has an invalid string"
try this
=DLookUp("Abr","tOffice","Office = " & "'" & ([Forms]![FReportSelect].[LocSelect]) & "'")
=DLookUp("Abr","tOffice","Office = " & "'" & [Forms]![FReportSelect].[LocSelect] & "'")
ASKER
Odd no errors but nothing is displaying. If I use just [Forms]![FReportSelect].[L
are you sure there are none null values on the table?
what happens when you try the actual value in debug window?
what happens when you try the actual value in debug window?
ASKER
nope no null values. Not sure how to the value in the debug in window - sorry
?DLookUp("Abr","tOffice","
and press enter
and press enter
ASKER
Where do I type that in to?
ASKER
I think in the Immediate window?
I did that and go the following error:
"Compile error, expected: list separator or )"
I did that and go the following error:
"Compile error, expected: list separator or )"
in code look for the immediate window.
or you can also type that in any query
or you can also type that in any query
what did you you type, post the value
ASKER
?DLookUp("Abr","tOffice","
ASKER
IF I do this ?[Forms]![FReportSelect]![
ASKER
Seems to be some sort of issue with dlookup
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That worked
ASKER
so ?DLookUp("Abr","tOffice","
ASKER
Got it now and I learned about the debug window! Thanks!
Does it exist as a value of Office in tOffice?
Is the confusion caused because of a table level lookup?