Hi,
I have 2 textboxes on my form (Namefilter and BirthYear filter) and have set them up to filter the data entered in my tables as i type (real time search as I type).
I need the 2nd filter (birthyear) to filter the results obtained by the first filter, but at the moment when I type in the BirthYear filter textbox it does the search from the original data and not the already filtered data.
How can I achieve my objective?
Ive attached my database below with some mock data.
I have 2 textboxes on my form (Namefilter and BirthYear filter) and have set them up to filter the data entered in my tables as i type (real time search as I type).
I need the 2nd filter (birthyear) to filter the results obtained by the first filter, but at the moment when I type in the BirthYear filter textbox it does the search from the original data and not the already filtered data.
How can I achieve my objective?
Ive attached my database below with some mock data.