Dlookup returning circular reference warning in control source

[Stephenson]

Hello all,



I'm working on my first report and am trying to get my textbox, tboJob to show a field value and not the ID. I have tried the following Dlookup in my control source with no luck.

=DLookUp("[JobName]","Jobs","ID=" & [tboJob])

JobName is the field I want to show from the table Jobs. I must be missing something simple. Please let me know what it is.

Thank you for having a look

[JamesDeckert]

does the report use a table or query for its data? This is where [jobname] should be available. You shouldn't need to lookup the value.

[Stephenson]

I'm using a table for the data

[Stephenson]

The table I'm using for the report is EmployeeWorkLog.

[John_G]

The circular reference error is due to the fact that you are using the value in tboJob to update itself, which means it would want to update itself again, etc. etc.....

A solution might be to put the JobID in an invisible report field tboJob, and then set another text field (e.g. tblName) using that value; the Dlookup you have would work.

Easier would be to use a query which contains the JobName as the report source. This is a common approach when creating a report that uses lookup values, instead of the ID's.

[Stephenson]

John_G,

Thank you for the help. I like the sounds of doing the query.

Please excuse my ignorance, but to do this all I would need to do is create a query from that table then include the fields I wish to use then use that query as my report source? I'm new to queries too.

Thanks for the help.

[John_G]

Your query would include the main table plus the lookup table(s). You would join the main tables to the lookup tables using the field common to both (JobID), and then in the query field list include the JobName from the lookup table . And yes, you would use the query as the record source for the report.

[Stephenson]

Thank you for the help John_G