VBA coding to filter data

[qwerty]

I have to two fields popmin and popmax, that uses one textbox.

The text box suppose work for example, say there data population of 15 to 80.
if someone enters 20 is 20 >= 15? T or 20 <= 80? T
If someone enters 100 is 100 >= 15? T or is 100 <= 80? F

Then it will show all the data in those ranges.

What be the best vba coding for this type of statement?

[ranman256]

you want 2 text boxes.
txtBoxMin, txtBoxMax

and a button to activate the filter:

sub txtButton_click()


   Me.Filter = "[population] between " & me.txtBoxMin & " and " & me.txtBoxMax
   Me.FilterOn = True


end sub

turn the filter off using the APPLY FILTER button on the toolbar.

[ssanfu]

There is not enough info to create any code.

Where is "....data population of 15 to 80."? A form, a query, a table???

Then it will show all the data in those ranges.

Shows it where???

[qwerty]

Population is in a query and it show the results in a listbox on a new page.

[qwerty]

There is not enough info to create any code.

Where is "....data population of 15 to 80."? A form, a query, a table???



Shows it where???

Population is in a query and it will show the results in a listbox on a new page.