w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Filter records in a subform based on selected record in another subform

on subform 1: Set an on click vba event on the field that would trigger a refresh. set it to requery the second subform, something like;

forms!mainform!subform2.requery

on subform 2:

Set the datasource of the second subform to contain all data. Then in the datasource set a filter criteria on the field that matches the field selected in the first subform. something like;

forms!mainform!subform1.form!fieldname

now when you click the field in subform1 it refreshes the subform 2, when the subform 2 is refreshed it looks what record is selected an what the value of the fieldname is and uses it as the filter.





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.