I have a listbox on mainform that goes to a specific applicant when clicked.. ="[Applicant_ID] = " & Str(Nz([Screen].[ActiveControl],0))
the issue i have is the applicant has a subform with more than one record, how can i filter the form to goto the specific record on the subform reported on the listbox.?
EG joe bloggs has 2 records on subform and displays twice on listbox but regardless of what joe bloggs i choose form the listbox. it always takes me to record 1 on the subform and i have to use navigation buttons to goto correct record. i am thinking i need some kind of filter additional step on the macro event..
take me to the applicant then filter on the app_ID..
the issue i have is the applicant has a subform with more than one record, how can i filter the form to goto the specific record on the subform reported on the listbox.?
EG joe bloggs has 2 records on subform and displays twice on listbox but regardless of what joe bloggs i choose form the listbox. it always takes me to record 1 on the subform and i have to use navigation buttons to goto correct record. i am thinking i need some kind of filter additional step on the macro event..
take me to the applicant then filter on the app_ID..