Need Help with creating a Search Option

[MChancellor]

My boss has asked me to add a search capability to a database. I have an idea, but I need to know whether or not it is even feasible. If it IS feasible, then what would be the best method for implementing it. My idea for the search capability is as follows:

Create a form that is identical to the data entry form (which contains all the information they could possibly want to know), and allow them to search on any of the available fields. Once they have entered the search criteria, then I need it to filter out only those records matching the criteria.

I do know somewhat about the workings of VB... and could code it if necessary.

I appreciate any assistance.

Thanks,
Misti

 

[nickjar2]

A good bet if the search form is to look identical as the data entry form is to use 'Filter by form'.

Let me know if u need more info.

Nick

 

[gwinn7]

What about using the built in Ctrl-F feature of Access to search based on bound controls? This is so easy, you don't have to program anything. Are your fields bound?

Gary
gwinn7

 

[MChancellor]

I have a rather interesting situation when I attempt the "Filter by Form" option.

If I filter by anything in the main form - the filter works great - does exactly what it is supposed to.

In the two subforms on the main form, the fields on the form are filled based on matching the ID number with the main form. When I try to "Filter by Form" based on the subform - it doesn't work at all. It gives me all the records in the database - without the information being filled in on the subform.

Is there a way to remedy this?

Thanks...
Misti