Need help with data filtering form (1 Viewer)

[nax009]

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:

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.

 

[theDBguy]

What is the big blank area in the middle? Is that a listbox or a subform?

 

[nax009]

What is the big blank area in the middle? Is that a listbox or a subform?

Hello. Yes, a list box name LstSection

 

[Josef P.]

2 Tasks:

1. generate filter expression (where condition)
- When changing the length option group, supply the textbox for manual filling with the appropriate value.
- generate condition string with textbox and option group of section

2. set the data source of the list box with this filter
- SelectSql = "select ... from ... where " & ConditionString

Details see attachment.

 

[nax009]

2 Tasks:

1. generate filter expression (where condition)
- When changing the length option group, supply the textbox for manual filling with the appropriate value.
- generate condition string with textbox and option group of section

2. set the data source of the list box with this filter
- SelectSql = "select ... from ... where " & ConditionString

Details see attachment.

Thank you josef, you've been helpful.