dlookup in report

Dear Experts

On an Access 2003 report I need a text box [Text24] to show the .tag from the report.  I have tried various ways including setting the control sourse of [Text24] to .tag but alas no joy.  Can this be done with a Dlookup - if so how? or any alternatives greatfully recieved
correlateAsked:
Who is Participating?
 
iandianConnect With a Mentor Commented:
euh sorry, it was a report, so
=[Report].[Tag]
as control source for the text box
0
 
RDWaibelCommented:
dlookup is for lookups on a data table.  what is the report.tag value?
0
 
RDWaibelCommented:
You should be able to add code in the reports OnLoad event to set the value of [Text24]

0
 
iandianCommented:
you can use
=[Form].[Tag]
as control source to display the tag of the form in the text box
0
 
correlateAuthor Commented:
Brilliant Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.