Link field to form

[kcmark]

I am writing a report that needs to pull a date field from a form. I am using the following command in the control source line of the report field, but it is giving me an #Name error on the report. Any idea what I am doing wrong?

=[Forms]![Pmt_Main]![PR_Date]

 

[scriverb]

The form must be open at the time the report is previewed or printed for this syntax to work. I am betting that you have the form closed when you tested the report.

let me know.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[kcmark]

I figured it out. The form I was calling was actually a subform and I forgot to include the parent form in the reference - a rookie mistake - uggggggghhhhhhhhhhhh