Report Lookups

[coynesj]

Can I do a lookup in a report from data in a form??

If so, how do I format it, cause I just can't it to work, I keep getting #Name? which leaves me thinking that I am just making some sort of syntax error...

Thanks in advance...

 

[apr pillai]

If the Form is open, when you run the Report, then you can use an expression similar to the one given below to reference a control on the form to display its value in a Textbox on the Report:

=[Forms]![Employees]![EMPCOD]