<div>
This works well.<br />
I also am playing with Tempvars, as this will allow me to use the same variable name in both places.
</div>


This works well.
I also am playing with Tempvars, as this will allow me to use the same variable name in both places.

<div>
You also can simply use a hidden control on the parent form and then simply set the master link property on the subform control to reference the hidden control.<br />
<br />
Unlike the child link, the master link can refer to a field or control on the parent. &nbsp;<br />
<br />
Everything after that is automatic.<br />
<br />
Jim.
</div>


You also can simply use a hidden control on the parent form and then simply set the master link property on the subform control to reference the hidden control.

Unlike the child link, the master link can refer to a field or control on the parent.  

Everything after that is automatic.

Jim.

<div>
Thank you both. I am tending to reprogram now and get rid of master/child links - I am finding much faster performance limiting the underlying recordset.
</div>


Thank you both. I am tending to reprogram now and get rid of master/child links - I am finding much faster performance limiting the underlying recordset.

<div>
<div class="content wysiwyg-content">
Dear experts,<br />
I have an issue where my subform is pulling all records, and I just need to view one, which will change dynamically based on other factors.<br />
I wanted to put an unbound control in the form HEADER, then requery the record source, setting one key field to the value of that control.<br />
How do I do this syntactically?<br />
The thing is that this subform appears in several places, so putting a literal string showing the parent is not ideal, as the parent will differ. Or do I create a string in the load event building this, based on what the parent form(s) are?<br />
Thanks!
</div>
</div>


Dear experts,
I have an issue where my subform is pulling all records, and I just need to view one, which will change dynamically based on other factors.
I wanted to put an unbound control in the form HEADER, then requery the record source, setting one key field to the value of that control.
How do I do this syntactically?
The thing is that this subform appears in several places, so putting a literal string showing the parent is not ideal, as the parent will differ. Or do I create a string in the load event building this, based on what the parent form(s) are?
Thanks!

SQL recordsource - refer to control on the subform?

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.