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;


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;


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.