Greeting folks.
I need some help with VBA coding for my filtering form contain a listbox: LstSection which have data from a query name q_mat_A06_00 . Here is the fields and some example data in q_mat_A06_00:
Here is my form design:
My requirement:
- Let user filter SECTIONTYPE by using SecFilter toggle buttion group and filter LENGTH by using Lenfilter option buttons group at the same time.
- User can filter LENGTH by any value outside the available option button by inputing in txt_lengt textbox
- User can choose to show all the LENGTH.
Thank you in advance.
I need some help with VBA coding for my filtering form contain a listbox: LstSection which have data from a query name q_mat_A06_00 . Here is the fields and some example data in q_mat_A06_00:
ID (Primary key) | CODE | SHORTNAME | DESCRIPTION | LENGTH | SECTIONTYPE |
1 | A 06 00 00 | A-6 m. | Section A 6 m. long | 6 | A |
2 | A 06 00 01 | E-9 m. | Section E 9 m. long | 9 | E |
3 | A 06 00 02 | K-10 m. | Section K 10 m. long | 10 | K |
Here is my form design:
My requirement:
- Let user filter SECTIONTYPE by using SecFilter toggle buttion group and filter LENGTH by using Lenfilter option buttons group at the same time.
- User can filter LENGTH by any value outside the available option button by inputing in txt_lengt textbox
- User can choose to show all the LENGTH.
Thank you in advance.