We help IT Professionals succeed at work.

How do I show record source name in text box

Medium Priority
306 Views
Last Modified: 2012-05-12
I am created a report in access, and want to show the name of the record source in a text box, but cannot figure how or what the correct syntax is.

I have tried ="Report" & [Record source]

Please advise ! - Thanks :)
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
try

="Report " & Reports![NameOfreport].Recordsource

Author

Commented:
tried that just got #Name? on the viewed report ????
CERTIFIED EXPERT
Top Expert 2016
Commented:
did you change this "NameOfreport" with the ACTUAL name of the report?

Author

Commented:
oh no duh!!!!!!!!!!!

Thanks mate :)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.