Searching for a range of values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.

jahoobob via AccessMonster.com said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top