Isolation in Forms

[McObraz]

Hello all,

I have a form on to which a sub-form is attached. I wish to have an event such that, on the user clicking the Admission Number or ID (In Blue), only the record clicked upon remains on the form.

However, ideally, I would be interested in a solution that posits the Admission Number clicked to the unbound field on top, then the query runs, because the next action that I carry out (printing of a report), depends on the data having been isolated all the way to the query level.

Kindly find database attached.

Any help will be appreciated.

Thanks.
Maurice

 

[llkhoutx]

Use an unbound AfterUpdate event of that combo box filter the form recordsource with that value.