getting value for a report from a form based on current form
Posted on 2015-02-19
I have an unbound control or field on a report that I would like to get the contents from an active and open form. Using the following syntax doesn't seem to work for me:
frmCCOrder is the name of my main form, frmCCFormLineItems is the name of my subform where my control lies, and txtProject is the name of the control from which I want to retrieve my data.
All I get when I preview the form using this is ?Name.
Any idea what I may be doing wrong?