Search form Identical to active form...

[caman74]

Hello.

I've been using Filemaker for some db development, and I liked the search method there, and I'm wondering if there is any way to make this work in Access.

In Filemaker there is one search button, that "turns" the active form into a search form.
It will search for records depending of what is written/ typed in the different textboxes.

If you have 20 textboxes on a single form, you can enter info in, let say, 8 of this textboxes when you are in search mode, and it will only display records matching all criterias.

I found that function wery handy, and would like to implement that into my db, if it is possible.

Any ideas??

Chris

 

[Pampers]

Access has the similar functionality. You can use on the menu:

records/filter/filterbyform. The textboxes will no function as filters. Use the filterbutton to execute the filter.



Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

How are ya caman74 . . .

Besides [blue]pampers[/blue] post, you also filter in code using the [blue]Filter & FilterOn[/blue] properties . . .

See Ya! . . . . . .