Recent content by 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.

Actually you don't need to mess with queries anyway. The DLookUp function is designed to do just this without the need for a query. Try setting the Control Source property of your textbox to =DLookUp("[Status]","Status","[ID] = " & [Status])

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...

I figured it out. The name of my field is Auto Number not AutoNumber. In my display box "AutoNumber=1" is what was displaying. Thanks anyway.

Hi. I've been working on a database for awhile now and I have a button on a form that is supposed to apply a filter based on criteria from the user. However when I actually go to apply the filter in the code I get an message asking to input the value for the filter even though I stated it in the...