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?