Question about pulling data from other tables

hammerva

Registered User.
Local time
Today, 18:58
Joined
Dec 19, 2000
Messages
102
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
 

Users who are viewing this thread

Back
Top Bottom