Control Source

[Alexander]

I use data from one query to build a report and also need to pull data from another for a few fields, specifically a text box, in the report. What is the code to link them? I tried putting [Forms]![rptViolationsbyCategory]![Text98]in the criteria of the field in the query that has the information, wherein "rptViolationsbyCategory" is the report that needs the info and "Text98" is the field where I need to put the info, but I must have done something wrong because it is not working. I need a bit of help.

Thanks,

Alexander

 

[Philem]

Hullo. I generally will have a report get information from ONE query. It's easier to make one more query that has ALL the fields the report will need, than trying to get the sometimes dodgy report engine to do this.

HTH

P