#Error returned when using a as parameter in expression

[Fr33dan]

On my report I tried to use the DLookUp function to get a persons full name based on their initials (which is stored in the author field). For my subreports this worked great but on the main report the expression is returning "#Error". In trying to figure it out I tried setting a new TextBox's expression to just be the author field and that to causes the error. If I directly link the box to the field it displays properly though.

Expression I need to work:

=nz(DLookUp("[Name]","People","[Initials] ='" & [Author] & "'"),"Author Unknown")

Test expression that also generates error:

=[Author]

 

[Fr33dan]

Having spent all day working on this I finally figured out that it was because the name of the text is also author. This was causing a conflict and giving me an error.