Searching for a range of values

[Guest]

I want to search my db for boats between 20 ft and 65 ft on a form. I use a
continuous form with search parameters at the top and the results shown at
the bottom. How can I use a text box for the Min/Max values. The field is
[LOA] and contains the length of each boat. Any help is appreciated.

Don

 

[jahoobob via AccessMonster.com]

Easy way is to create two unbound text boxes on the form called lo and hi.
Create a query of your boat information table and in the criteria for the LOA
field place BETWEEN [Forms]![Nameof SearchForm].[lo] AND [Forms]![Nameof
SearchForm].[hi]. Make the record source of the form this new query

I want to search my db for boats between 20 ft and 65 ft on a form. I use a
continuous form with search parameters at the top and the results shown at
the bottom. How can I use a text box for the Min/Max values. The field is
[LOA] and contains the length of each boat. Any help is appreciated.

Don

 

[Guest]

Unfortunately that won't work in my situation because my form also has other
search parameters on it and they use a different record source. Do you know
of any code that I can write to accomplish this task using my existing record
source ( which is a table containing all the fields that I need.

Thanks.

Easy way is to create two unbound text boxes on the form called lo and hi.
Create a query of your boat information table and in the criteria for the LOA
field place BETWEEN [Forms]![Nameof SearchForm].[lo] AND [Forms]![Nameof
SearchForm].[hi]. Make the record source of the form this new query

I want to search my db for boats between 20 ft and 65 ft on a form. I use a
continuous form with search parameters at the top and the results shown at
the bottom. How can I use a text box for the Min/Max values. The field is
[LOA] and contains the length of each boat. Any help is appreciated.

Don