Subform2.png

<div>
Thanks! Quick fix to what should have been a simple issue. <br />
=[Forms]![frmCCOrder]![frm<wbr />CCFormLine<wbr />Items].[Fo<wbr />rm].[txtPr<wbr />oject]<br />
instead of <br />
=[Forms]![frmCCOrder]![frm<wbr />CCFormLine<wbr />Items].[tx<wbr />tProject]
</div>


Thanks! Quick fix to what should have been a simple issue.
=[Forms]![frmCCOrder]![frmCCFormLineItems].[Form].[txtProject]
instead of
=[Forms]![frmCCOrder]![frmCCFormLineItems].[txtProject]

<div>
Speedy response, saved the day! Thanks again.
</div>


Speedy response, saved the day! Thanks again.

<div>
I don't Think it will be possible to do that if the control is in details or group section of the report,<br />
you can use global or public variable to hold the required value when report shown and access that variable
</div>


I don't Think it will be possible to do that if the control is in details or group section of the report,
you can use global or public variable to hold the required value when report shown and access that variable

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
=[Forms]![frmCCOrder]![frm<wbr />CCFormLine<wbr />Items].[tx<wbr />tProject]<br />
<br />
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.<br />
<br />
All I get when I preview the form using this is ?Name.<br />
<br />
Any idea what I may be doing wrong?
</div>
</div>


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:

=[Forms]![frmCCOrder]![frmCCFormLineItems].[txtProject]

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?

getting value for a report from a form based on current form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.