Hello all, how are you doing. I have a report that is pulling data from Requirement History. I want to include a field that takes data from a Description field in Requirments. I set the control source to "=[Requirements]![Requirement_Description].[Value]". But it brings up a message box looking for Requirements.

I probably need to set a SELECT into that table to pull the data and stick into the field. But do I put it in the Open or Activate event of the report. Also, was Property is used to put value is. I can't find a VALUE or TEXT property with report fields

Hope didn't confuse too much. Thanks alot

Use a query to join the tables and base the report on that or you can use DLookUp
HTH