smtazulislam
Member
- Local time
- Today, 18:42
- Joined
- Mar 27, 2020
- Messages
- 806
Any help will appreciate
I have a subform Like :
And I create a Main form that is data RecordSource to tblclient table.
I want to create two combo box (Year) and (Month) for filtering record in the subform on based Joindate ;
If I choose from combo box year : 2020 then need display record Only 2020 year date from JOINDATE :
If I choose from combo box year : 2020 and Month : May then need display record Only 2020 from JOINDATE
if I reset (Year = "" and Month = "") then show all data
can possible to filtering.
I have a subform Like :
ID | ClinID | JoinDate | LeftDate |
01 | 25 | 01/02/2020 | 03/03/2020 |
02 | 26 | 02/05/2020 | 15/09/2021 |
03 | 27 | 15/01/2021 | 01/03/2021 |
And I create a Main form that is data RecordSource to tblclient table.
I want to create two combo box (Year) and (Month) for filtering record in the subform on based Joindate ;
If I choose from combo box year : 2020 then need display record Only 2020 year date from JOINDATE :
ID | ClinID | JoinDate | LeftDate |
01 | 25 | 01/02/2020 | 03/03/2020 |
02 | 26 | 02/05/2020 | 15/09/2021 |
ID | ClinID | JoinDate | LeftDate |
02 | 26 | 02/05/2020 | 15/09/2021 |
if I reset (Year = "" and Month = "") then show all data
can possible to filtering.