Creating a search function with data parameters

[jmc1]

How would one create a search function that would filter and limit a certain number of forms based on a data parameter. Ex: search values in securities greater than 400 but less than 900, and have the forms with values less or greater than the parameter set be filtered out.

[Minty]

There are many examples of search forms - but this one is probably the best one.
http://allenbrowne.com/ser-62.html

You may be able to use something based on a form like this to then filter subsequent forms, not super simple but certainly achievable.

[davegri]

I think there's a terminology problem here.
You can search Tables and Queries, but not Forms.
For example, you can search for a particular value (or range of values) in a Field within a Table. The 'data parameters' would be entered by the user into a Form control.
The results of the search could be displayed on a Form or in a Report.

Within this context, can you clarify your requirements?

[jmc1]

Sorry..new to this and have been put under the gun to learn it... I am essentially creating a database of profiles for Banks and tasked with creating a search function in the form that allows one to filter profiles(records) through the data parameter entered into the search function. This search function would obviously be linked to the table or query I constructed and linked to the form.. but do I create the search function in the form or in the table or query??

[orange]

As davegri said -there is an issue with terminology. There is a certain jargon associated with database and with Access.

It is better for posters -especially new to database posters - to clearly describe what you are trying o support/automate in clear, simple English. We don't know you, your experience, your environment....so make it real simple and clear so readers can understand what you are trying to accomplish.

Good luck with your learning and project.

Here is a link to a recent analogy of what a database is conceptually. It doesn't all apply to you, but starting with "Actually.." is a simple analogy that may help.

[davegri]

but do I create the search function in the form or in the table or query??

Since the search parameters are entered by the user into the form, code behind the form could either set and apply the filter values
OR
the code behind the form could modify the form's recordsource query to pull only the profiles that satisfy the query's criteria (based the data parameters entered).

[jmc1]

This sounds like exactly what I am trying to accomplish.. I dont mean to be annoying but could you give a basic overview of the steps to create this code and the steps to get to the platform of implementing the code.

[jmc1]

modifying the recordsource would be the correct direction I believe

[davegri]

could you give a basic overview of the steps to create this code and the steps to get to the platform of implementing the code.

Can you download your database? A real working example would avoid a dozen exchanges here to get good end results.
All I need is the table with a few records. You can change the bank name to dummy it up. If you have a form, you could include that too, along with any supplemental queries or tables needed by the form.
If you don't have a form, what do you need to search for?

[orange]

jmc1,

Did you look at the Allen Browne link that Minty provided?

Here's a link to a keyword search video by Steve Bishop.